List:General Discussion« Previous MessageNext Message »
From:Nitin Date:October 13 2003 8:21am
Subject:Re: How does LIMIT affect Query Caching
View as plain text  
Sorry for wrong answer, actually, that's the behavior of oracle query cache,
so I guessed it would be same for MySQL too. I sincerely apologize for any
inconvenience caused.

Nitin

----- Original Message ----- 
From: "Dan Nelson" <dnelson@stripped>
To: "Nitin" <nitinmehta@stripped>
Cc: "Reto Baumann" <mysql@stripped>; <mysql@stripped>
Sent: Monday, October 13, 2003 12:03 AM
Subject: Re: How does LIMIT affect Query Caching


> 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
>
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
http://lists.mysql.com/mysql?unsub=1
>


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