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