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