Why MySQL insists on ignoring the query cache whenever
I use the same query repeatedly to populate a temp
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?
Do you Yahoo!?
Yahoo! Mail - You care about security. So do we.