Re: Moving data from HEAP table to KEY partitioned ISAM table - advice needed

[Rick James]

100M rows -- does that equate to about 3GB of table size? How much RAM do you have?

These have radically different performance characteristics:
LIKE 'abc%'
LIKE '%abc%'
Which are you doing?

Please do SHOW CREATE TABLE.

Partitioning for this case does not help performance.

Please do EXPLAIN SELECT ...;

If you are currently using a MEMORY table, do you realize that the data has no 'persistence'?