MySQL Forums :: Newbie :: Question about LIMIT


Advanced Search

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,
Dmitriy

Options: ReplyQuote


Subject Written By Posted
Question about LIMIT Dmitriy Reznik 12/22/2010 07:59AM
Re: Question about LIMIT Peter Brawley 12/22/2010 08:41AM
Re: Question about LIMIT Dmitriy Reznik 12/22/2010 08:50AM
Re: Question about LIMIT Peter Brawley 12/22/2010 10:47AM
Re: Question about LIMIT Dmitriy Reznik 12/22/2010 03:05PM
Re: Question about LIMIT Peter Brawley 12/22/2010 03:16PM
Re: Question about LIMIT Dmitriy Reznik 12/28/2010 08:06AM
Re: Question about LIMIT Rick James 12/22/2010 04:38PM
Re: Question about LIMIT Dmitriy Reznik 12/28/2010 08:08AM
Re: Question about LIMIT Rick James 12/28/2010 03:23PM
Re: Question about LIMIT Dmitriy Reznik 12/29/2010 08:26AM
Re: Question about LIMIT Dmitriy Reznik 12/29/2010 08:53AM
Re: Question about LIMIT Rick James 12/29/2010 09:42AM
Re: Question about LIMIT Dmitriy Reznik 12/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.