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 the execution plan of the
query. so, in your example it'll treat both query as same
, 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
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
