List:General Discussion« Previous MessageNext Message »
From:Nitin Date:October 12 2003 1:48pm
Subject:Re: How does LIMIT affect Query Caching
View as plain text  
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.

Enjoy
Nitin
----- Original Message ----- 
From: "Reto Baumann" <mysql@stripped>
To: <mysql@stripped>
Sent: Sunday, October 12, 2003 6:25 PM
Subject: How does LIMIT affect Query Caching


Does somebody know, how the LIMIT statement does affect the query caching
mechanism of MySQL 4.x?
Is
    select * from examples LIMIT 0,30
and
    select * from examples LIMIT 30,30

treated the same, therefore does the caching improve performance or are
these queries considered to be two sepperate queries?

Thanks for the help
reto


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