limitation of tables

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: egami, macek, gesf

Post Reply

Mon Apr 14, 2003 11:24 am

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.

New php-forum User
New php-forum User
Posts: 23
Joined: Tue Jun 24, 2003 4:49 am

Wed Jun 25, 2003 10:50 am



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.


Edit: Sorry I had not seen it was such an old topic :)

Post Reply