Hello.
As said at:
http://dev.mysql.com/doc/mysql/en/query-cache-how.html
A query will not be cached, if it uses TEMPORARY tables.
Homam S.A. [EMAIL PROTECTED] wrote:
Why MySQL insists on ignoring the query cache whenever
I use the same query repeatedly to populate a temp
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