limitation of tables

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

Moderators: macek, egami, gesf

renee

limitation of tables

Postby renee » 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.

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

Postby Flood » Wed Jun 25, 2003 10:50 am

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 :)


Return to “phpMyAdmin”

Who is online

Users browsing this forum: No registered users and 0 guests