Re: Oracle DB Connections and WWW

What you can do is use your pro*c program to manage the connetions. You would need to maintain a table of available connections and some sort of timeout mechanism. You could design your web pages so that after initially accessing you front page, a connection id is maintained and passed with each reqest for additional data. If you do not need to maintain any sort of state information, you could simply open a number of connections and use any that are not actively processing a request to handle a new request.

Hope this helps

Bob
In article <321097FA.7ECE_at_dma.isg.mot.com>, davidb_at_dma.isg.mot.com says...
>
>We are using Pro*c to link Oracle with our Intranet. Our system works
>fine, the only problem is that since WWW is connectionless, our system
>must re-connect to the database at the beginning of each page. This is
>producing some serious overhead. Does oracle provide any mechanism to
>open a connection, and allow other processes to use this connection.
>If not, does anyone have any suggestions on how to remedy this problem
>without a major development effort?
>
>Thanks in advance,
>
>Dave Bornstein
>Motorola ISG
>davidb_at_dma.isg.mot.com
>(508)261-5009
Received on Thu Aug 22 1996 - 00:00:00 CEST