; <[EMAIL PROTECTED]>
Cc: "Reto Baumann" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
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
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 minimi
ly 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 s
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 sepper
