List:General Discussion« Previous MessageNext Message »
From:Homam S.A. Date:February 11 2005 8:25pm
Subject:Why MySQL doesn't cache queries that populate temp tables?
View as plain text  
Why MySQL insists on ignoring the query cache whenever
I use the same query repeatedly to populate a temp
table?

So I have:

create temporary table MyTable
select SQL_CACHE * from SomeTable WHERE (A bunch of
criteria) limit 1000;

SomeTable is a read-only table.

If I issue the query without the temp table
population, it gets cached fine. It's just when I use
the temp table MySQL stops caching.

Is there a way to force MySQL to repopulate the temp
table from the cache?

Thanks!



	
		
__________________________________ 
Do you Yahoo!? 
Yahoo! Mail - You care about security. So do we. 
http://promotions.yahoo.com/new_mail
Thread
Why MySQL doesn't cache queries that populate temp tables?Homam S.A.11 Feb
  • Re: Why MySQL doesn't cache queries that populate temp tables?Gleb Paharenko14 Feb