ASP / PHP & MySQL / MSSQL ??

[RazorSA]

Hi there,

We are going to be starting a large project for Varsity. Web Based with VB backend prog.

Should we use MSSQL or MySQL ??

- I heard that MSSQL can store procedures that you can call up. Can you call up these functions over the web ? PHP style ?

Can MySQL also store procedures ???

Should we use PHP or ASP ??

- Have coded a little bit in both. Tempted to go PHP cause there are a lot of examples on the Web.

What does everyone think ???

[Tim Dorr Veteran]

Stored Procedures aren't in MySQL IIRC, but you can probably get away without using those. It's a pretty advanced feature.

As for the language to use, go with PHP. It's more wide spread on webhosts and probably will be faster and more efficient to code for.

Hope you go with the powerhouse combo - PHP/MySQL :D

[blackbird]

Not sure of your budget constraints or of the price of MYSQL, but MSSQL 2000 can be pricey. Beyond that, its up to you.

If it were me I would give serious consideration in starting your new project in ASP.NET and running it against SQL2k.

[RazorSA]

Well,

We can get ANY software that we need. It is not for commercial use. It is a University project and we can run ANY MS product.

I have not heard alot about the stored procedures and am quite interested in it.

Can anyone help ??

[iUk]

I would use ASP and Microsoft SQL Server.

The technology is far more robust and MS SQL Server can handle a much better load, as well as using Transact-SQL, Stored Proceedures, XML, etc.

ASP is a very powerful and flexible tool to use. I would actually recommend ASP.Net. Get VisualStudio.Net Enterprise Edition and install the whole thing on your workstation, then install just the server components on what ever server you will be using. Use MS SQL Server 2000 on another server or on the same server, it just depends on how much of a load you need to balance.

Then any Visual Basic developer can build web applications, web services using XML and SOAP, and any other Win32 application as well, all using the same style of interface that they are used to from VisualBasic 6.0.

I have used ASP for years and am now learning ASP.Net. They are far more efficient technologies than PHP and now that ASP.Net is compiled, it is faster and more efficient than anything before.

I would be happy to go into more detail with you if you would like. Email me at [email protected] and I can be more specific and helpful if I know some of the details. I know plenty of names of books, references, etc...

iUk

[zivan56]

Since you are using a VB backend, you should probably use ASP. If you want to control ever variable and have complicated and advanced stuff, go with PHP. You can learn how to use COM object in php here

[Glowstick]

I wound definitely try the ASP.NET way, it's the powerfullest server side thing yet. It compiles your .ASPX files into native code and caches them. It's speed matches ISAPI applications, means way faster than interpreted stuff like normal ASP or PHP.

If you need to rely on speed, get MSSQL, if you're short on money get MySQL.

[zivan56]

I woudnt agree with that, Zend Optimizer makes PHP run way faster. I installed IIS on my win2k machine and ever time it would takes it like 3 secs to get data from mysql with the harddrive grinding. In PHP just gets it in less than a sec (if that). Plus there are lots of PHP host and not many good ASP hosts.