Re: 90GB table on Windows 2000

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Thu, 31 Oct 2002 20:02:56 -0000
Message-ID: <3dc3880d_2@mk-nntp-1.news.uk.worldonline.com>

"Pablo Sanchez" <pablo_at_dev.null> wrote in message news:Xns92B79E788151Cpingottpingottbah_at_209.189.89.243...
> "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in news:appmaq$h7q$1
> $8302bc10_at_news.demon.co.uk:
>
> >
> > But I won't hold you to the GBP 100 -
>
> In one of my situations, I was under a tremendous performance shadow.
> Regardless of what tuning we did with the I/O subsystem, the RDBMS and
> some minor tunes to the app, it wouldn't go. Final diag: seems that
> the RDBMS needs some IPA'ing (*) among some other h/w vendor trickery.
>
> (*) IPA - interprocedural analysis - 15% perf gain.
>
> I'm not a compiler bit-head by any stretch ... but I do understand the
> general principles of what needed (and needs) to happen.
>
> btw, maybe he could buy you a beer? <g>
> --
> Pablo Sanchez, High-Performance Database Engineering
> http://www.hpdbe.com

More than happy to. I might get to the UKOUG in Birmingham, but that's about as far as my employers will pay to send me (unless of course it's one-way <g>).

I stand corrected.

Cheers,
Paul Received on Thu Oct 31 2002 - 14:02:56 CST