IM>I'm not either sure if they're used during normal operation, but that way
IM>could get a file number like (x / 3) + [a few files] where x is the
IM>files with MyISAM. Also, InnoDB should support .frm:less tables someday
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
IM>tables is a very rare problem.
IM>Best sql,query (forgot this the first time :-) regards,
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
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
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 ...