表大小是否影响INSERT性能？ [英] Does table size affect INSERT performance?

问题描述

这是一个问题，只是为了询问：

This is a question just for the sake of asking:

禁止所有中间到高级主题或技术（聚集索引，BULK INSERTS，导出/导入技巧等） 。），INSERT需要更长的表增长吗？

Barring all intermediate to advanced topics or techniques (clustered indices, BULK INSERTS, export/import tricks, etc.), does an INSERT take longer the larger a table grows?

这假设只有一个自动int列，ID [ie，所有新行都是INSERTED

This assumes that there is only one auto-int column, ID [i.e., all new rows are INSERTED at the bottom, where no memory has to shuffled to accommodate a specific row positioning].

链接到一个好的基准MySQL会很方便。我在学校里带了甲骨文，到目前为止，知识已经使我对SO没有什么好处。

A link to a good "benchmarking MySQL" would be handy. I took Oracle in school, and so far the knowledge has done me little good on SO.

感谢大家。

推荐答案

我的经验是，如果数据集索引不再适合内存，性能会下降。一旦发生这种情况，检查重复的索引将必须命中磁盘，它会显着减慢。使用尽可能多的数据来创建一个表格，你认为你必须处理，并做一些测试和调整。这真的是知道你会遇到什么的最好的方法。

My experience has been that performance degrades if the dataset index no longer fits in memory. Once that happens, checks for duplicate indexes will have to hit disk and it will slow down considerably. Make a table with as much data as you think you'll have to deal with, and do some testing and tuning. It's really the best way to know what you'll run into.

这篇关于表大小是否影响INSERT性能？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！