Re: pinning a table in memory

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Fri, 29 Nov 2002 21:28:19 -0000
Message-ID: <3de91e0d_1@mk-nntp-1.news.uk.worldonline.com>

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:mFJF9.86408$g9.242343_at_newsfeeds.bigpond.com...
>
> "David Sharples" <david.sharples3_at_ntlworld.com> wrote in message
> news:XdxF9.1137$zz5.86904_at_newsfep3-gui.server.ntli.net...
> > We have a largeish table (6 million records) and the queries we have on
> this
> > table are a tad slow and the disk is the bottleneck.
> >
> > We have considered putting the table in cache (alter table xyz cache)
> >
> > Was wondering if this would help very much seeing as though the indexes
> for
> > this table is still held on disk.
> >
> > Any opinions??
>
> Hi David,
>
> Tune your queries, just tune your queries ...
>
> Richard
> >

Richard,

How polite. I was just about to reply: "TUNE THE BLOODY CRAPPY SQL THAT THE APPLICATION SUBMITS" (as I think I said a while back). But of course, given you courteous response, I won't say that...

Regards,
Paul Received on Fri Nov 29 2002 - 15:28:19 CST