I tried the NOCOPY in my IN OUT parameter in one of my procedure today,
It worked OK ( at least it did not cause any slow down), tomorrow I am
going to try it on my another procedure , which return around 7K to 9K
rows of records by user. My question is how do I benchmark the
performance with this addition? ( I know it will be faster, but how
much). Does anyone have a generic ruler to measure it verse without
it?
My system is 8.1.6 on NT 4 with one 650 Mhz CPU 520 M memory. Thanks.
C Chang
Received on Tue May 21 2002 - 23:43:14 CDT
