On 10/11/12 19:54, Jeff Butera wrote: > In an attempt to improve performance, I've taken to replicating the > spouse field in the DONOR record by using an update trigger on PERSON to > ensure spouse is updated in DONOR as well. By replicating the spouse > in DONOR, I eliminate one TRANS in each field and cut my 640000 PERSON > reads to 320000 reads. > > That said, I'm looking for other means - this is one place where Pick > isn't my friend as we often have reports written out of various tables > and need to use 32+ TRANS statements to pull in PERSON demographic > info. Any insight appreciated.
Don't quote me on this, you'll need someone at Rocket to confirm it, but as far as I know, TRANS *does* cache the records it's read. So if you make multiple references to SPOUSE, unless you trans a different file or record in the interim, multiple consecutive accesses to the same record won't need to make multiple reads. Cheers, Wol _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
