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 *
|