MySQL Forums
Forum List  »  Optimizer & Parser

Re: Help with ORDER BY with LIMIT
Posted by: Lukas Pilny
Date: May 11, 2010 06:05AM

Thanks a lot for input, and apology at the same time...

When you said: "This will sort before doing the LIMIT: ORDER BY lastname LIMIT 0, 300" I looked again on the query and run test directly in MySQL and then in my API. And of course fault was in my paginator script (it was losing the search criteria when going to page 2). I simply misunderstood the sentence in manual and created whole bunch of wrong thoughts about possible reasons...

I would maybe ask mods here, to delete this post, as it is totally misleading and has nothing to do with problem/optimizing MySQL sorting with limit...

And if it you want to leave it, for all others like me: !!Check always that your paginator script is calling the same query as it is on first page. MySQL ORDER BY with LIMIT works just fine!!

Nice day to all

Options: ReplyQuote

Written By
May 09, 2010 02:24PM
May 10, 2010 10:59PM
Re: Help with ORDER BY with LIMIT
May 11, 2010 06:05AM

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.