I believe, for the most part, you are correct, but doesn't TRANS also do some work with the system delimiters? Such as a LOWER() or RAISE() function on the data that is returned? Something in the back of my head is hitting me on this but it may be if you're going to be accessing more than one field from the same record. In that case I'd always do an OPEN/READ, but I'd always try to limit the OPEN statement, especially if you're calling this subroutine from a DICT entry.
Bob W > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:owner-u2- > [EMAIL PROTECTED] On Behalf Of Glenn Herbert > Sent: Thursday, October 06, 2005 4:54 PM > To: [EMAIL PROTECTED]; u2-users@listserver.u2ug.org > Subject: RE: [U2] OPEN vs TRANS > > The vlist should show a call to Ftrans, which basically does an OPEN > and a READ, and caches both for later reuse (subsequent reads on a > file open'd earlier don't waste the time of the open). I also believe > that the file cache is for 10 files, then the oldest gets closed, and > the record cache is for 50 records between all open files. If you do > multiple TRANS ops on the same file same record, but different fields, > you only pay the cost of search for the field (assuming your file and > record are still IN the cache!) > > Hope this helps > > Glenn > > ______________________________________________________________________ > > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of "Hennessey, > Mark F." <[EMAIL PROTECTED]> > Sent: Thursday, October 06, 2005 2:55 PM > To: u2-users@listserver.u2ug.org > Subject: RE: [U2] OPEN vs TRANS > > I think you could test this by writing the code both ways, then doing > a VLIST to see what actual basic object code would be. > -----Original Message----- > From: George Gallen [mailto:[EMAIL PROTECTED] > Sent: Thursday, October 06, 2005 2:11 PM > To: u2-users@listserver.u2ug.org > Subject: [U2] OPEN vs TRANS > Is there any savings on using TRANS() vs > an OPEN at the top and a READ in the program > (Assuming I am only reading 1 record 1 time) > This is using UV10 > George ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
