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.
You think it would, or it already has in your testing? Heap vs. MyISAM is not that much of a speed up on an OS that caches well even in the ideal situation for HEAP.
Does making a heap file this large make any sense?
Actually, there is no file. It is all in memory. But if you have the RAM the size should not be a problem.
Are there size limitations to heap tables?
Amount of RAM + max_heap_table_size setting in the server.
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
