Board index   FAQ   Search  
Register  Login
Board index php forum :: Database phpMyAdmin

limitation of tables

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

Moderators: macek, egami, gesf

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

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 :)
Flood
New php-forum User
New php-forum User
 
Posts: 23
Joined: Tue Jun 24, 2003 4:49 am


Return to phpMyAdmin

Who is online

Users browsing this forum: No registered users and 1 guest

Sponsored by Sitebuilder Web hosting and Traduzioni Italiano Rumeno and antispam for cPanel.

cron