Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

--- Calculating optimal packet size ----------

Status
Not open for further replies.

DaniDak

Technical User
Mar 13, 2002
44
0
0
US
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.

Thanks
 
Try a series of experiments with various packet sizes, and measure whatever it is you're trying to optimise.

I guess you're referring to this right?

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.

--
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top