Connection speed tips
Posted: Tue 15 Mar 2005 10:06
Hello,
as everybody know, oracle is slow when you open a connection to it, well, I have a web application that uses oracle data on every page, anybody have a tip or sample code to avoid the client to be waiting for the connection to be opened?
I've tried at global.asax to open a connection when the application starts and assign it to a session object for each new user, closing it when session ends, it works, but I think that is not the best way.
Can anybody help me with this?
Thanks!
as everybody know, oracle is slow when you open a connection to it, well, I have a web application that uses oracle data on every page, anybody have a tip or sample code to avoid the client to be waiting for the connection to be opened?
I've tried at global.asax to open a connection when the application starts and assign it to a session object for each new user, closing it when session ends, it works, but I think that is not the best way.
Can anybody help me with this?
Thanks!