Friday, March 16, 2012

Optimum minpoolsize?

Hello,

In connection pooling, how do I determine the optimum number for minpoolsize ?

Thanks!Rule of thumb is 5. To truly determine the minimum pool size will require you to do load testing on your application with various pooling sizes. I doubt that the return justifies the effort, but that's the answer.
Thanks! Are there any downsides to setting the minimum pool size and using connection pooling? I read that an exception is generated when a connection is severed. Any suggestions from someone who has used it
Yes, there is a popular "General Network Error.." associated with connection pooling (http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/support/kb/articles/Q229/5/64.asp&NoWebContent=1

0 comments:

Post a Comment