IIS 5 & IIS 6
How to enable connection pooling with ADODB.Connection
Last post Oct 05, 2008 05:43 PM by steve schofield
Oct 04, 2008 03:18 AM|rw97540|LINK
Is there a way to enable connection pooling with ADODB.Connection? I have seen several things that say to call SqlSetEnvAttr which is impossible to do from Classic ASP (unless I'm missing something).
I found the KB article 237844 which also says the same. This is IIS 6. Thanks
Oct 04, 2008 11:33 PM|steve schofield|LINK
See if this article helps.
Windows Server MVP - IIS
Log archival solution
Install, Configure, Forget
Oct 05, 2008 07:35 AM|rw97540|LINK
Thanks. That's basically the answer. It appears that some of this code is trying to open a new recordset when one is already open and it is creating an implied connection which is not part of the connection pool.
By using Performance monitor to watch logins/sec, and stepping through the code it's pretty quick and easy to issolate where these "bugs" are.
Oct 05, 2008 05:43 PM|steve schofield|LINK
I'm glad that was helpful. What I did on a high volume site I used to run was create an application variable in the global.asa and refer to that instead of explicitly creating a new connection. The cpu on the web server went from 30% to 40% to 10% to 12%
when connection pooling was enabled. This was a few years ago, but it made me a believer of connection pooling. :)