Re: Tuning attempt

"Ricky Sanchez" <rsanchez_at_more.net> wrote in message news:3E92F1CF.162D9D0E_at_more.net...
> Marc-
>
> With all due respect, what does pin hit ratio have to do with anything
> at this point? If you think you have a performance problem, you need to
> consider this approach:
>
> 1. find the worst bottleneck
> 2. relieve it
> 3. go to 1, repeat until done

There is at least one problem with this approach. It is an infinite loop. There will always be a bottleneck. The goal should be repeat until performance is acceptable.

I'd also personally change it so that it reads

1. Find where you are spending your time
2. Minimise time spent there
3. repeat until elapsed time is acceptable to end users/ management.

--
Niall Litchfield
Oracle DBA
Audit Commission UK