We want to convert a 200+ meg table to a heap table. We've gotten pretty good performance converting from InnoDb to MyIsam table but converting to a heap table would give an even bigger performance boost.
Does making a heap file this large make any sense? Are there size limitations to heap tables? TIA Dan