Re: Responsiveness of Server at high CPU load

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Thu, 18 Dec 2003 01:17:39 +0100
Message-ID: <3iq1uvg9foil8ek69hg48dkk781ntopav9@4ax.com>

Sybrand Bakker <gooiditweg_at_sybrandb.nospam.demon.nl> wrote:

>Preferred course of action:
>1 fix your statements
>2 fix your statements
>3 fix your statements
>4 stop symptom fighting
>if all fails ...
>look in to using resource plans

Mr. Bakker, you might be so right. I will analyze the statement more thoroughly. It has something like

select these, those
from this, that
where this IN (select .... from <table with millions of rows> where etc.)

If the subselect returns many rows, IN is a nightmare.

I will let you know.

But: this is not MY statement!

Bye
Rick Denoire Received on Wed Dec 17 2003 - 18:17:39 CST