title: Should I create a Mysql table using a MEMORY (HEAP) engine or MyISAM engine?
body: <p>I want to increase the speed of some database queries I am running on a MySQL MyISAM table that is one gigabyte in size.</p>
  
  <p>The table has about 10 million rows and has about ten columns of INTs and VARCHARs. The table is used only for READs and there will be no updates or inserts into the table. The only query that I do on the table is:</p>
  
  <pre><code>SELECT name,age FROM myisamtable WHERE category1='example' AND (category2='example2' OR category4='example4') ORDER BY id DESC LIMIT 1000,2000
  </code></pre>
  
  <p>Should I convert the table to Memory for faster performance? (I don't care if I lose the table on system restart). Or is it better to keep it as MyISAM and increase some settings like the key buffer size, etc..? </p>