Is there a limit for the number of tables in a database? I have more than 1000 tables now and myphpadmin db_details_structure.php3 doesn't work well sometimes.
Handles large databases. We use MySQL Server with databases that contain 50 million records. We also know of users that use MySQL Server with 60,000 tables and about 5,000,000,000 rows.
It has never happened to me, I guess that the main problem you can encounter when using a lot of tables regards speed: the more tables you join in your requests (especially if each of them has a lot of tuples), the slower you will get the results... Well, that is what sounds logical to me at least!
Hope it helps.
/Flood
Edit: Sorry I had not seen it was such an old topic
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.