,
Robin
-Original Message-
From: Almar van Pel [mailto:[EMAIL PROTECTED]]
Sent: 05 February 2002 00:02
To: [EMAIL PROTECTED]; Robin Keech
Subject: RE: performance help required. (2G -> 4G Ram upgrade)
Hi,
Your problem is that your query uses all of the rows in the table. That
means that
,
Robin
-Original Message-
From: Almar van Pel [mailto:[EMAIL PROTECTED]]
Sent: 05 February 2002 00:02
To: [EMAIL PROTECTED]; Robin Keech
Subject: RE: performance help required. (2G -> 4G Ram upgrade)
Hi,
Your problem is that your query uses all of the rows in the table. That
means that
e for maintenance periodically to optimize these heavy
tables.
Regards,
Almar van Pel
-Oorspronkelijk bericht-
Van: Jeremy Zawodny [mailto:[EMAIL PROTECTED]]
Verzonden: dinsdag 5 februari 2002 0:04
Aan: Robin Keech
CC: '[EMAIL PROTECTED]'
Onderwerp: Re: performance help required
On Mon, Feb 04, 2002 at 05:41:46PM -, Robin Keech wrote:
> (Please reply directly, I am only on the digest list, thanks)
>
> I have an SQL statement that is taking far too long to run, around
> 11 minutes (while locking inserts/updates).
>
> We have installed some more RAM, and I need help w
