RE: performance help required. (2G - 4G Ram upgrade)

2002-02-12 Thread Robin Keech
, 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

RE: performance help required. (2G - 4G Ram upgrade)

2002-02-05 Thread Robin Keech
, 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

performance help required. (2G - 4G Ram upgrade)

2002-02-04 Thread Robin Keech
(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 with my.cnf and the troublesome SQL. Can anyone suggest some config

Re: performance help required. (2G - 4G Ram upgrade)

2002-02-04 Thread Jeremy Zawodny
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 with

RE: performance help required. (2G - 4G Ram upgrade)

2002-02-04 Thread Almar van Pel
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. (2G - 4G Ram