13:08
To: U2 Users Discussion List
Subject: Re: Help Needed regarding performance improvement of delete
query
Great points from Wol, as always.
What kind of /tmp disk space do you have on this system?
(Assuming that /tmp is where UV does some of it's SELECT
scratch pad intermediate writing when
In a message dated 3/15/2004 9:54:01 AM Eastern Standard Time, [EMAIL PROTECTED]
writes:
10 READNEXT ID ELSE STOP
READV DTE FROM F.MASTER, ID, 5 ELSE GOTO 10
IF DTE GT DEL.DATE THEN GOTO 10
DELETE F.MASTER, ID
DELETE F.REFERENCE, ID
GOTO 10
I count three goto's
So three
Gives Mark the most improved player award.
Will
In a message dated 3/16/2004 5:07:09 PM Eastern Standard Time, [EMAIL PROTECTED]
writes:
LOOP WHILE READNEXT ID DO
READV DTE FROM F.MASTER, ID, 5 THEN
IF DTE LE DEL.DATE THEN
DELETE F.MASTER, ID
DELETE
-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 16, 2004 6:08 PM
To: U2 Users Discussion List
Subject: Re: Help Needed regarding performance improvement of delete
query
Gives Mark the most improved player award.
Will
In a message dated 3/16/2004 5:07:09 PM Eastern Standard
, March 15, 2004 4:50 PM
To: ashish ratna
Subject: RE: Help Needed regarding performance improvement of delete
query
Ahhh
I thought you were selecting records and deleting them. So the first
thousand would have disappeared, and you would obviously get a different
thousand next time round because
: Help Needed regarding performance improvement of delete query
This might help speed things up a bit ...
Firstly, of course, is your file properly sized?
Secondly, (and in this case you will need to run the SELECT / DELETE
sequence several times) try putting a SAMPLE 1000 (or whatever number
makes
, 2004 7:55 AM
Subject: RE: Help Needed regarding performance improvement of delete query
Hi Wol,
The scenario is that-
We have a master file having more than 3-4 million records and have corresponding
reference file which contains reference data for this master file.
Now we start our
, 2004 8:24 AM
Subject: Re: Help Needed regarding performance improvement of delete query
I forgot to mention why.
U2 definately prefers ADDing records instead of DELETing records.. any day.
- Original Message -
From: ashish ratna
To: Anthony Youngman
Cc: [EMAIL
PROTECTED]
To: Anthony Youngman [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Monday, March 15, 2004 7:55 AM
Subject: RE: Help Needed regarding performance improvement of delete query
Hi Wol,
The scenario is that-
We have a master file having more than 3-4 million records and have
corresponding