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.
----- Original Message -----
From: "Reto Baumann" <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?
select * from examples LIMIT 0,30
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