MySQL的VS的SQL Server 2005/2008的性能 [英] MySQL vs SQL Server 2005/2008 performance

问题描述

我打算开始开发一个ASP.NET应用程序，我不知道要使用哪个数据库。性能是非常重要的，该数据库应能无问题来处理数据库的大约50GB。然而，我想知道，如果一个SQL Server许可证是值得付出的。我已经找了MSSQL服务器（2005/2008）和MySQL之间的性能和可扩展性的比较，但我似乎无法找到任何好的测试。你能指出我与此相关的问题的一些广泛的基准测试？

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?

推荐答案

如前所述，MySQL能够提供高读取性能（假设简单的查询，很少或根本没有连接），只要你使用默认的表类型。

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

然而，你还指出该数据库是50GB的大小，这说明你可能会寻找将的可靠的存储信息的数据库。使用默认的表类型MySQL是不是由任何发挥想象力的一个可靠的数据库。

However you also stated the database is 50GB in size, which suggests you may be looking for a database that will reliably store the information. Using the default table type MySQL is not a reliable database by any stretch of the imagination.

如果你想有一个快速，自由的替代MS SQL那么PostgreSQL的可能是一个不错的选择 - 它是快速可靠，并具有更加开放的许可证（如果你使用MySQL的一个商业项目，你会想读它的双牌照非常仔细地）。唯一的缺点PostgreSQL是它共享一些相同的DBA导师要求甲骨文，那里的MS SQL通常可以通过一个普通IT人员管理，而MySQL不需要太多的管理，除了每次恢复旧的备份它决定损坏和数据丢失。

If you want a fast, free alternative to MS SQL then PostgreSQL may be a good choice - it is fast reliable, and has a more open licence (if you use MySQL for a commercial project you'll want to read its dual licence very carefully). The only downside to PostgreSQL is that it shares some of the same DBA guru requirements as Oracle, where as MS SQL can often be managed by a regular IT person, and MySQL doesn't need much management besides restoring the old backups everytime it decides to become corrupted and lose your data.

这篇关于MySQL的VS的SQL Server 2005/2008的性能的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！