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
Hi All,
We are working for purging of old data from the database. But we are facing
performance problems in this.
We are using select query which is created dynamically on the basis of number of
records. We want to know if there is any limit for size of query in Universe.
Although in
, 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
10 matches
Mail list logo