Menu
I intend to start developing an ASP.NET application and I am wondering which database to use. Performance is very important and the database should be able to handle without issues a database of about 50GB. I am wondering however, if a SQL Server license is worth paying for. I have looked for performance and scalability comparisons between MSSQL Server (2005/2008) and MySQL but I can't seem to find any good tests. Can you point me to some extensive benchmarks related to this subject?
347
For the INSERT operations, MySQL worked faster than SQL Server. For transaction processing, MySQL is fast. With the help of its InnoDB storage engine, MySQL can handle high concurrency for transactions. However, MySQL struggles with reporting workloads, mainly when there are queries that need to join large tables.
Both MySQL and SQL Server are developed as binary collections. But, SQL Server is far more secure than MySQL. MySQL allows developers to access and manipulate files in the database through binaries at run time. Plus, it also allows other processes to access and modify files at run time.
Microsoft SQL Server 2005 follows the Fixed Lifecycle Policy. Support for this product has ended.
MySQL traditionally is very fast if you are doing a lot of reads. For example in a web site there is probably a 100 to 1 read write ratio so MySQL works well. If you are planning a high transaction database then head straight to MSSQL. If money is no issue head straight to MSSQL anyway because it is a better product.
193
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
