List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 12 2003 6:33pm
Subject:Re: How does LIMIT affect Query Caching
View as plain text  
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
Thread
How does LIMIT affect Query CachingReto Baumann12 Oct
  • Re: How does LIMIT affect Query CachingNitin12 Oct
    • Re: How does LIMIT affect Query CachingDan Nelson12 Oct
  • Re: How does LIMIT affect Query CachingNitin13 Oct