On Mon, 2006-04-03 at 10:28 +0800, Foo Ji-Haw wrote: > Perrin Harkins wrote: > > Jeff wrote: > >> Your application simply uses approach (b) and MySQL does the rest > >> automatically. So if you > > Have 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. > I have, and I can verify that MySQL does some kind of internal > 'caching', so that the next limit call is very fast.
How do you know it isn't just the operating system caching the disk fetches? The docs certainly make it sound like a query cached with LIMIT will not be useful when different LIMIT values are applied. - Perrin