Move million records from MEMORY table to MYISAM table.
Posted
by Prashant
on Stack Overflow
See other posts from Stack Overflow
or by Prashant
Published on 2010-04-13T09:19:22Z
Indexed on
2010/04/13
9:23 UTC
Read the original article
Hit count: 370
Hi,
I am looking for a fast way to move records from a MEMORY table to MYISAM table. MEMORY table has around 0.5 million records. Both tables have exactly the same structure (same number of columns, data types etc.). But the MYISAM table is indexed (B-TREE) on a few columns. There are around 25 columns most of which are unsigned integers.
I have already tried using "INSERT INTO SELECT * FROM " query. But is there any faster way to do this?
Appreciate your help.
Prashant
© Stack Overflow or respective owner
