MySQL Forums
Forum List  »  Performance

Re: Insert problems on very large DB
Posted by: Roland Rabben
Date: November 25, 2004 02:32PM

Thanks, it looks like a solution for me. Need to do some more testing but early results show a big improvement in using DISABLE/ENABLE KEYS as opposed to DROP/CREATE INDEX.

The date colum is incremental. I guess I could split the large table in smaller tables containing records for each day in each table and then create a MERGE TABLE using all the underlying tables. But how do I index the the merge table. Do I create indexes on every underlying table, or do I create one index on the merge table?

If i have to create an index on the merge table, wont the index be the same size/length as the index for the large table any way?

Options: ReplyQuote


Subject
Views
Written By
Posted
3788
November 25, 2004 07:32AM
2341
November 25, 2004 09:47AM
2220
November 25, 2004 01:21PM
2278
November 25, 2004 01:48PM
Re: Insert problems on very large DB
2339
November 25, 2004 02:32PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.