469,625 Members | 1,086 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,625 developers. It's quick & easy.

Table Number Limit?

Is there a limit to the number of tables allowed in MySQL? Is there any
non-obvious performance hit associated with having too many tables?

Assume the data size will be the same. In other words, having a table that
is 1.5Gig versus having 1000 tables that are each 1.5MB in size.

Jul 19 '05 #1
1 2183
Just a passing observation, tables are in a lot of cases stored as files so perhaps one factor is how your OS copes with looking up files in a directory
Jun 27 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Bing Wu | last post: by
3 posts views Thread by ken | last post: by
9 posts views Thread by bill | last post: by
139 posts views Thread by ravi | last post: by
reply views Thread by debasisdas | last post: by
12 posts views Thread by enrique | last post: by
6 posts views Thread by shawno | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.