On Nov 27, 2007 10:21 AM, mos <[EMAIL PROTECTED]> wrote: > At 05:57 PM 11/26/2007, you wrote: > >The second query might be faster due to caching. > > This can be verified by executing: > > RESET QUERY CACHE > > before executing the second query. This will clear the queries from the cache.
No need to blow your whole cache. Just do this on the session you test from: SET SESSION query_cache_type = OFF; However, while this disables the query cache, it doesn't reset the caching of disk data, which is the most likely reason for queries to run faster the second time. The needed index or data records will be in RAM the second time the query is run. - Perrin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]