Re: Help with ORDER BY with LIMIT

[Lukas Pilny]

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