ssage-
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:0
t;[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Tuesday, March 16, 2004 6:08 PM
Subject: Re: Help Needed regarding performance improvement of delete query
> Gives Mark the "most improved player" award.
> Will
>
> In a messa
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
> DELE
you go (to).
- Original Message -
From: <[EMAIL PROTECTED]>
To: "U2 Users Discussion List" <[EMAIL PROTECTED]>
Sent: Tuesday, March 16, 2004 4:33 PM
Subject: Re: Help Needed regarding performance improvement of delete query
> In a message dated 3/15/2004 9:54:01 AM East
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 thre
ehalf Of Scott Richardson
Sent: 15 March 2004 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
cent.
- Original Message -
From: "ashish ratna" <[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
H
on List
Sent: Monday, March 15, 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
Youngman [mailto:[EMAIL PROTECTED]
Sent: Monday, 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
, 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
reference file which contains reference data for this master file.
Now we
PROTECTED]>
Sent: Monday, March 15, 2004 4:02 AM
Subject: RE: 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 se
, 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
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 sense) at the end of your select.
Basically, this will mean
13 matches
Mail list logo