On Tue, 10 Feb 2004, CSN wrote:
>
> --- "scott.marlowe" <scott(dot)marlowe(at)ihs(dot)com> wrote:
> > >What's weird is that when the same query
> > is
> > > executed again, it seems much faster - some sort
> > of
> > > caching maybe?>
> >
> > Yep. Exactly.
>
> Really? Where can I RTFM about it?
Not sure. Basically, your kernel should be caching a fair bit. See what
top says about cache and buffer size. If you've got a big enough kernel
buffer, and the table gets hit often enough, it should stay in kernel
memory.