D
dbeavon
Guest
Did you explicitly use the "BY-REFERENCE" option on the TT parameter? (I don't use internal procs but if they are anything like class methods, you should still ask for "BY-REFERENCE" parameter handling). Sometimes it is hard to tell when OE is making a new instance of the same data. I think the trick I normally use is to create a million rows and see if there is an increase in the overhead when crossing the boundary between the caller and callee. (There will be a performance impact if new copies of temp data are created). As I recall there may also be some a VST that tell you details about the static TT's in your session, and you can see if the number of TT's increases at different points on your callstack. A new reference to a temp-table shouldn't change the numbers in the VST.
Continue reading...
Continue reading...