I think that since Image already has the list and fields in the buffer, it
would be simpler to just use *. I don't think there would be any marked
performance difference.
***************************************************************
CDR Paul Edwards USNR Ret. HP 3000/9000 Certified Consultant
Paul Edwards & Associates Phone: (972) 242-6660
1506 Estates Way Fax : (972) 446-9022
Carrollton TX 75006 Cel : (214) 384-8728
Email: [log in to unmask] Web : www.peassoc.com
***************************************************************
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf
Of Ray Shahan
Sent: Tuesday, August 15, 2006 1:31 PM
To: [log in to unmask]
Subject: Re: [HP3000-L] Hmmm is IMAGE list processing not a problem anymore?
Ahh, yes, my example neglected to point out that the key is to remain the
same...thanks, though, Denys.
Ray S.
-----Original Message-----
From: Denys Beauchemin [mailto:[log in to unmask]]
Sent: Tuesday, August 15, 2006 1:26 PM
To: Ray Shahan; [log in to unmask]
Subject: RE: [HP3000-L] Hmmm is IMAGE list processing not a problem anymore?
Yes.
Seriously, from a timing POV, I don't think it makes much difference.
However, you should consider the possible ramifications of a DBUPDATE for
all the items if this is a detail dataset. Keep CIUPDATE in mind.
Denys
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf
Of Ray Shahan
Sent: Tuesday, August 15, 2006 1:15 PM
To: [log in to unmask]
Subject: [HP3000-L] Hmmm is IMAGE list processing not a problem anymore?
Hi all,
Given the scenario of 10 items in a data set (each item 6 bytes
long), an Image list of all 6 of the set's items was produced to read the
data set, but only one of the items is actually updated in a given
transaction: Is it faster to produce a new list for Image to use for the
update that would only update the one item in the data set that actually
changed, or is it quicker to just update all of the items in the set using
the "*;" construct?
TIA,
Ray Shahan
<http://www.republictitle.com/>
Ray Shahan
Computer Programmer
REPUBLIC TITLE OF TEXAS, INC. <http://www.republictitle.com/>
2701 W Plano Parkway
<http://maps.yahoo.com/maps_result?addr=2701+w+plano+parkway&csz=75075&c
ountry=us&new=1&name=&qty=>
Plano, TX 75075
direct 214.556.0202
main 972.578.8611
fax 972.424.5621
www.republictitle.com <http://www.republictitle.com/>
[log in to unmask]
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|