limitation of tables

[renee]

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.

[Flood]

Hi!

See http://www.mysql.com/doc/en/Features.html

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