In the last episode (Sep 25), David Bordas said:
> I've just a little question for the end. I planned to have around 10K
> tables under a DB and this number surelly grow up to 20K. I know that
> a database is a directory and a table is 3 files. I just want to know
> is mysql have a limit in the number of table per database.
>
> If not, i know that ext3 can have ten of thousands files in a
> directory. But commande like 'ls' will become slower and slower ...
> Is this also slowing mysql ?
"show tables" will be slow, for the same reason ls is slow: it has to
fetch the names of all 20k files. Direct access via mysql should be
fine.
--
Dan Nelson
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
