Re: Perf Tuning

From: Pablo Sanchez <pablo_at_dev.null>
Date: Mon, 13 May 2002 20:30:16 -0600
Message-ID: <3ce07519_11@news.teranews.com>

"Alex Ivascu" <alex_at_ivascu.com> wrote in message news:j0YD8.73019$071.26298968_at_typhoon1.we.ipsvc.net...
> Ouch!
>
> I did a simple test w/ 150K rows. It does seem to make a
difference (small
> one), but it does. Wonder why?
>
> Alex
> ps Thanks for your assistance, I'm just now trying to dig a little
deeper
> into tuning
>

Make sure to run your microbench several times (20 to 100?) so you can get rid of the noise -- which seems to be indicative in your case - 'small one, but it does' :)

--
Pablo Sanchez, High-Performance Database Engineering
mailto:pablo_at_hpdbe.com
http://www.hpdbe.com
Available for short-term and long-term contracts

Received on Mon May 13 2002 - 21:30:16 CDT