大数据库有什么DB？ [英] What DB for big databases?

问题描述

我正在开始一个项目，在不久的将来可能会跨越几百万行，所以我正在研究我使用的数据库，因为这肯定会证明一个问题。从我已经阅读，SQL在其所有的化身有问题，一旦你达到表的2,000,000行问题。有没有一个很好的数据库推荐用于这些大型项目？

I'm embarking on a project which will likely cross several million rows in the short future, so I am researching the database I use as that is sure to prove an issue. From what I have read, SQL in all its incarnations has issues once you get to the 2,000,000 rows issue for a table. Is there a good database recommended for these big size projects?

这是一个网站，我正在谈论，归档旧的条目是不理想，证明是我无法克服的问题。

It is a website I am talking about, and archiving old entries is not ideal, though can be done if it proves to be an issue that I can't overcome.

谢谢。

推荐答案

我已经在MS SQL Server中的表有一个公平的位超过200万行没有麻烦。当然，这取决于你如何使用这些数据。

I've had tables in MS SQL Server with a fair bit more than 2 million rows without trouble. Of course, it depends on how you're using that data.

只是不要尝试使用MySQL这样的东西。至少从我的经验，它只是不允许足够的调整提供足够高的性能。我遇到了几个案例与大量的数据（几乎）相同地设置表。 MySQL5执行的速度比同一硬件上的SQL Server慢30倍。极端的例子可能，但仍然。

Just don't try using MySQL for something like this. At least from my experience, it just doesn't allow enough tweaking to provide high enough performance. I've run into a few cases with large amounts of data in (almost) identically set up tables. MySQL5 performed like 30 times slower than SQL Server on the same hardware. Extreme example maybe, but still.

我有太少的经验与PostgreSQL或Oracle判断，所以我会坚持不推荐MySQL。或访问;）

I have too little experience with PostgreSQL or Oracle to judge, so I will just stick with not recommending MySQL. Or Access ;)

这篇关于大数据库有什么DB？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！