I believe this issue was addressed in a previous thread just last week - trans operations, whether with TRANS, XLATE, or Tfile conversion, utilize both a file and record cache to help alleviate these concerns. If you issue multiple statements against the same file and/or record, the open/read hit is only taken against the first statement. This does NOT alleviate the speed of field lookup traversal, only file/record open/reads....
In summary, the universe implementation is fairly efficient. Hope this helps. ______________________________________________________________________ From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of "Susan Lynch" <[EMAIL PROTECTED]> Sent: Tuesday, October 18, 2005 11:28 AM To: <[email protected]> Subject: Re: [U2] Translate question Has the internal implementation of this changed, or is this still as horrifically inefficient as it was back in the Microdata days? Except in a condition where you were doing a READV from a file that was not otherwise read in a Basic program, this was always strongly discouraged - as I found out when I asked Jon Sisk about it at a convention, and he literally fell on the floor laughing that someone was actually using this syntax. At that time, Chandru Murthi got up and helped him answer (both were laughing) - this syntax actually did a file open and then a READV, so that if you use it for more than one field in a record, or for multiple reads on a file in a Basic program, the OPEN being repeated was a killer in terms of performance (our software vendor did both, constantly!) I am surprised that no other responders raised the efficiency issue! Susan Lynch F.W. Davison ----- Original Message ----- From: "Mark Johnson" To: Sent: Monday, October 17, 2005 11:16 PM Subject: [U2] Translate question > I've always used the OCONV(ID,"TFILE;X;15;15") form for translates. What is > the difference between the first and second '15's. I've seen "X;;15" work and > "X;15" not work. > > Thanks in advance. > Mark Johnson > ------- > u2-users mailing list > [email protected] > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
