Splitting large tables and creating MERGE tables - 08-20-2007 , 07:06 AM
I've currently got a sizeable MySQL database (using MyISAM tables)
where one table holds about 5 million entries, and SELECT queries are
really starting to slow down.
It seems that it would probably be more beneficial to split this down
into a few hundred tables and access the data via a MERGE table.
I can easily write a PHP script to recursively create the new tables
and move the relevant data accross to the new tables, then I can
create the new MERGE table.
My query is that because the current table is indexed, when I split
the existing table out into smaller tables, should I re-index each
table before I create the MERGE table ?