阅读背景:

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.I know that in SQL Server, the maximum number o




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: