Multiple Database Connections vs Single Database Connection
I have an Oracle database which I want to connect to. I have an app running on my IIS server which the users will connect to.
The normal scenario is to when a request come to the web server it opens a connection to the database and then closes it when it is finished. This means for every client connection to the web server there is one to the server ... so if we have 1000 web connections we have 1000 database connections. This eats up too many resources.
I know that you can use some sort of session information to keep one database connection open and all the web requests use the same database connection.
I would like to get some information for it. And if anybody can give me a working ORACLE and C# example, you get the 500 points :)