Hello, If the number of files is your concern, have you considered using InnoDB? It spans tables across any number of data files you want. The performance is great, too.
Best regards, Iikka On Wed, 25 Sep 2002, David Bordas wrote: > Hi list, > > 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 ? > > Thanks > > > --------------------------------------------------------------------- > 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 > ****************************************** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ****************************************** --------------------------------------------------------------------- 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
