I know what you are trying to get at. A full select and a select with
limit have the same query speed, but the full select has to transfer all
of the selected data, where as a limit only transfers the number of
records specified. The more records that match a search, the faster your
limit
[snip]
Now comes my question, what is better speaking of performance:
When users go on to the next page, is it better to
provide the select statement again with a different integer for
the limit?
Or is better to do a full select without a limitation on first page.
But than I don't know how