wolfie wrote:
Doesn't ASP allow you to use the MySQL database though? This is what I've heard because essentally, a SQL database is a SQL database, it's just different coding on the programmers part. But aparently, somebody has connected a ASP 3.0 query to a MySQL database. Im not tottaly sure seeming as I have a small site that uses Access.
|
Yes you can connect to mySQL from ASP, you just the the myODBC driver installed on the server and you can connect to it pretty much the same as you do with access or mssql but some querys syntax is a little different and the methods are also different... but you still can code an application with queries that are access, mssql, and mysql compatible just gotta to change your way of coding...
While it's said that MSSQL is faster than MySQL I've found that PHP and mySQL will beat ASP and MSSQL anytime...
About PHP vs ASP I think PHP is a much faster and powerful scripting language than ASP... you can do a lot more with plain PHP while with ASP you need components for pretty much everything...
Some people find PHP is a little to code than ASP because it uses a lot more characters that you gotta hit SHIFT to produce like $, {}, etc.., but that don't really make it harder cuz something that might take 50 lines of code on ASP can be done with 10 lines of PHP...
One thing I like about ASP is that everytime I download an ASP script it's usually easy to understand and well commented so you can learn a lot from other people's work, but most PHP scripts are 'optimized' when you download it so you can't understand the code cuz in PHP you can compress a 500 lines file into a 10 lines file and it will still run and authors do that to protect their work...
About .NET I haven't learned anything about it yet, the applications I've seen on .NET seems to run very fast but also lack a lot of functionality but I guess that not a fault on .NET but on the app developers.