Hi
pabloj, I think you better go read the PC Magazine article again:
Click on the scorecard link to see the results.
MySQL came dead last it only scored well in the performance sector.
btish, the whole article will be of value to you as a whole as it compares all the top major RDBMS vendors out there.
The RDBMS were reviewed in 8 key areas:
security
performance
management tools
server engine
database design
interoperatability
data analysis
programmability
As the review said MySQL is fast but falls short in all the other areas. It came last in everything except performance.
Admittedly when it came to programmability SQL Server only scored 3, mysql 2 but this was because of SQL Server's poor Java performance. When it was used with asp it flew.
Speed is one thing but when working with databases and the internet security is another thing. As a DBA security is one the most important aspects of my job.
Stored procedures and views aid this as you can limit access to tables through stored procs and views. Ideally you applications should only use stored procs to query the tables and then you pages called the procedures. Same with views. The less direct access to the base tables the better.
MySQL relies on 3rd party management tools unlike most database packages who ship with their own tools. SQL Server's tools are very ease to use and work with.
As PC Mag says:
"The SQL Query Analyzer is the most polished and functional tool we saw for tuning manual SQL queries"
MySQL also doesn't support constraints which means you have to code in all the checks to make sure that incorrect data isn't inserted. This means more code.
In my opinion since you are using asp stick to sql server. It performs well and is easy to use. If you plan to use a Unix environment go with Oracle, if it is a NT environment go with SQL Server.
After all as Oracle states "The internet runs on Oracle".
They are being honet. If money isn't an object then go with Oracle.
Hope this helps
John
