Hi, IM>I'm not either sure if they're used during normal operation, but that way you IM>could get a file number like (x / 3) + [a few files] where x is the number of IM>files with MyISAM. Also, InnoDB should support .frm:less tables someday in IM>2003 (at least www.innodb.com says so). But if you bump into problems IM>with InnoDB, are you sure your database design is right? I mean, the number of IM>tables is a very rare problem.
IM>Best sql,query (forgot this the first time :-) regards, IM>Iikka I don't know well InnoDB and i need to spend some times to learn InnoDB mechanism and new variables before i can use it ... Why create several tables ? In fact, for the moment i have a big MyISAM table with around 5 Millions of rows. The app that's using this table connect to a mysql server form a LAN. And performance isn't as best as i want. I have a search query that's sloowwww. So i try lots of thing to change the SQL of this query, trying fullsearch ... but do not see good results ... I look at my table structure and i found that i have a field like a category in fact. And i only read, update and delete row on one category at a time. Like a sub tables ... So i thinking to split the table by this category field. I'll have more tables, but smaller ones and lock table will be better ... Thanks David --------------------------------------------------------------------- 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
