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 > 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 > -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
