title: A persistent temporary table?
body: <p>Right now, I'm using temporary tables in my select queries to speed up the execution. They are created every time I execute the query.</p>
  
  <p>In my current situation, the tables are updated with new data only once per day, so I was thinking that instead of using MySQL's <code>CREATE TEMPORARY TABLE</code> statement, I'll create a persistent table, which in a sense would be <em>temporary</em> since it'd be deleted and recreated after a day. And I could fill it up with the <em>temporary</em> data just after I've finished updating the main tables.</p>
  
  <p>Or, will <code>InnoDB's data buffer</code> will be smart enough to cache the data for temporary tables itself?</p>
  
  <p>Or is there another way for caching the temporary tables?</p>
  
  <p>I'm also sending along appropriate cache headers with the data loaded using AJAX to reduce server load, and AJAX queries make up about 70% of the read requests sent to mysql. </p>
  
  <p>Is what I'm thinking just a plain waste of disk space and tables are never meant to be used in this fashion, or is it a really bright idea for my situation?</p>