Maximum number of workable tables in SQL Server And MySQL
Posted
by Kibbee
on Stack Overflow
See other posts from Stack Overflow
or by Kibbee
Published on 2009-03-04T14:56:12Z
Indexed on
2010/04/23
3:43 UTC
Read the original article
Hit count: 383
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.
© Stack Overflow or respective owner