I have a web application that is largely driven by ASP Code. The backe end is oracle.
While I was profiling my application to speed it up, I noticed that server.createobject("adodb.connection") sometimes is very slow. It typically takes anywhere between 10 and 2000 milliseconds.
Quite often, it takes 10-100 millisecond. But sometimes it can be very slow.
I was wondering if there are any windows settings that i could tweak to speed up the process.
This is a virtual directory on Wink2k IIS5.0. ASP Engine is 5.6 and ADO version is 2.7
Appreciateyour BIG HELP