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 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]