SQL Server和MySQL中的最大可使用表数 [英] Maximum number of workable tables in SQL Server And MySQL

问题描述

我知道在SQL Server中，数据库中对象"的最大数量略超过20亿个.对象包含表，视图，存储过程，索引等.我完全不担心超出20亿个对象.但是，我想知道的是，SQL Server是否因拥有大量表而遭受性能下降.您添加的每个表是否会对性能产生影响，还是基本上没有区别(假设数据量恒定).是否有人在处理具有数千个表的数据库方面有任何经验?我也想知道关于MySQL的问题.

I know that in SQL Server, the maximum number of "objects" in a database is a little over 2 billion. Objects contains tables, views, stored procedures, indexes, among other things . I'm not at all worried about going beyond 2 billion objects. However, what I would like to know, is, does SQL Server suffer a performance hit from having a large number of tables. Does each table you add have a performance hit, or is there basically no difference (assuming constant amount of data). Does anybody have any experience working with databases with thousands of tables? I'm also wondering the same about MySQL.

推荐答案

假设数据量恒定，则没有区别.

No difference, assuming constant amount of data.

由于减少了维护窗口(减少了索引重建)，具有只读文件组等功能，因此在实践上可能有所收获.

Probably a gain in practical terms because of things like reduced maintenance windows (smaller index rebuilds), ability to have read-only file groups etc.

性能由查询和索引(在最基本的级别)决定:不是对象数

Performance is determined by queries and indexes (at the most basic level): not number of objects

这篇关于SQL Server和MySQL中的最大可使用表数的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！