Hi, I'm not either sure if they're used during normal operation, but that way you could get a file number like (x / 3) + [a few files] where x is the number of files with MyISAM. Also, InnoDB should support .frm:less tables someday in 2003 (at least www.innodb.com says so). But if you bump into problems with InnoDB, are you sure your database design is right? I mean, the number of tables is a very rare problem.
Best sql,query (forgot this the first time :-) regards, Iikka On Thu, 26 Sep 2002, Pete Harlan wrote: > On Wed, Sep 25, 2002 at 08:49:43PM +0300, Iikka Meril?inen wrote: > > 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. > > The .frm files are still there, though, one per file. Maybe they're > not used during the operation of the db...? I don't know about that. > > --Pete > ****************************************** * 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
