MySQL Forums
Forum List  »  Newbie

Question about LIMIT
Posted by: Dmitriy Reznik
Date: December 22, 2010 07:59AM

Dear experts,

I tried to use LIMIT to make my application more efficient loading only 100 records at each page. But I just noticed that a query with LIMIT 1, 100 takes same time to execute as a query without it. Is it true that LIMIT doesn't make a query to execute faster? Is there any other way to select only 100 records instead of all that query would return?

Thank you very much,

Options: ReplyQuote

Written By
Question about LIMIT
December 22, 2010 07:59AM
December 22, 2010 08:41AM
December 22, 2010 08:50AM
December 22, 2010 10:47AM
December 22, 2010 03:05PM
December 22, 2010 03:16PM
December 28, 2010 08:06AM
December 22, 2010 04:38PM
December 28, 2010 08:08AM
December 28, 2010 03:23PM
December 29, 2010 08:26AM
December 29, 2010 08:53AM
December 29, 2010 09:42AM
December 29, 2010 09:55AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.