Hi
How can I calculate the optimal PACKETSIZE needed for my stored procedure that returns large record sets back to the calling C program for further process.
So also vary other key parameters and try and figure out a minimising relationship, based on the results you get.
But are you sure you're optimising the right thing here? It seems to me that this isn't going to be the most expensive bit of the operation. Copying seems cheap compared to the actual SQL lookup which leads up to it, and the processing you do in your C code after it.
Vast improvements may have only a small effect on the overall performance.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.