Universe does some caching around TRANS from memory. So if you want to only do lookups your results may indicate a good solution. However, for update it will not work, and depending on the number of files being accessed, you may find there are issues with the cache being rotated.....
> -----Original Message----- > From: [email protected] [mailto:u2-users- > [email protected]] On Behalf Of DavidJMurray (mvdbs.com) > Sent: Tuesday, 19 October 2010 1:01 p.m. > To: [email protected] > Subject: Re: [U2] Stumped with TRANS... > > > > > FFT2001 wrote: > > > > Has anyone done a timing test to compare a SUBR which uses a common > > section to store an opened file variable > > > > vs a TRANS ? > > _______________________________________________ > > U2-Users mailing list > > [email protected] > > http://listserver.u2ug.org/mailman/listinfo/u2-users > > > > > > I did a simple timing and comparison test some time ago: > > http://mvdbs.com/2006/01/25/timing-trans-and-read/ > http://mvdbs.com/2006/01/25/timing-trans-and-read/ > > Cheers, > > David J Murray > > > ----- > > Learn and Do > Excel and Share > > > http://mvdbs.com http://mvdbs.com > -- > View this message in context: http://old.nabble.com/Stumped-with- > TRANS...-tp29910397p29995851.html > Sent from the U2 - Users mailing list archive at Nabble.com. > > _______________________________________________ > U2-Users mailing list > [email protected] > http://listserver.u2ug.org/mailman/listinfo/u2-users > _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
