MySQL and SQL Server 2005/2008 Performance

Question

I intend to start developing an ASP.NET application, and I wonder what database to use. Performance is very important, and the database should be able to process a database of about 50 GB without any problems. However, I am wondering if it is worth paying for a SQL Server license. I was looking for a comparison of performance and scalability between MSSQL Server (2005/2008) and MySQL, but I can not find any good tests. Can you point me to some extensive criteria related to this topic?

Answer 1

As already mentioned, MySQL can provide high read performance (assuming simple queries with few or no connections) as long as you use the default table type.

However, you also indicated that the database size is 50 GB, which suggests that you can look for a database that will reliably store information. Using the default table table MySQL is not a reliable database for any part of the imagination.

If you need a quick, free alternative to MS SQL, then PostgreSQL may be a good choice - it is reliable and has a more open license (if you use MySQL for a commercial project, you will want to read its dual license very carefully). The only drawback for PostgreSQL is that it shares some of the same DBA guru requirements as Oracle, where MS SQL can often be managed by regular IT staff, and MySQL does not need much management, except to restore old backups every time. when it decides to get corrupted and lose your data.

Answer 2

MySQL is traditionally very fast if you read a lot. For example, there is probably a read / write ratio of 100 to 1 on the website, so MySQL works well. If you plan to create a high transaction database, then head straight to MSSQL. If the money is not released directly in MSSQL, as this is the best product.