In the last episode (Oct 12), Nitin said:
> query cache doesn't cache the data, but the execution plan of the
> query. so, in your example it'll treat both query as same, as both
> are fetching data from same result set. query cache just increases
> the speed of query "execution", that means minimizes the time taken
> to actually execute the query, not the time taken to fetch the data
> from the database.
Actually, the query cache doesn't cache the execution plan; it caches
the query string, so any difference from query to query, including
spaces and capitalization, is important.
http://www.mysql.com/doc/en/Query_Cache_How.html
--
Dan Nelson
dnelson@stripped
