Connection Pooling

oodesigns · Post by **oodesigns** » Tue 31 Jul 2007 15:55

Hi

Looking at the connection pool source, it appears that if it cannot get a connection from the pool as the other connections are buzy, after 30 seconds you will get an error. Can an option be added just to wait for ever as some of our requests could be longer and this would cause problems.

Thanks

Mike

Antaeus · Post by **Antaeus** » Wed 01 Aug 2007 12:26

It is unlikely that we will add such option. You just need to increase the value of the MaxPoolSize parameter.

oodesigns · Post by **oodesigns** » Fri 03 Aug 2007 06:36

Hi

I do not want to do that, for when I am determining the number of threads i used I wanted it to be independant of the SQL connection count, but when performing our standard thread optimisation routine the connection request times out and we are processing 1500 request over a time period of 2 minutes. I really would like to use connection pooling so instead of having a connection per thread we can fine tune it.

Please will you re-consider your position.

All the best

Mike

oodesigns · Post by **oodesigns** » Fri 03 Aug 2007 09:11

- Do not worry we have decided not to use pooling at all.

All the best...