Perrin Harkins wrote:
I have, and I can verify that MySQL does some kind of internal 'caching', so that the next limit call is very fast.Jeff wrote:Your application simply uses approach (b) and MySQL does the rest automatically. So if youHave you tried this? I was under the impression that MySQL would just stop when it finds enough row to satisfy LIMIT, so it wouldn't cache the whole result set.