perl-modperl mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Perrin Harkins <>
Subject Re: Database transaction across multiple web requests
Date Mon, 03 Apr 2006 02:55:54 GMT
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

View raw message