Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Multiple db connections

Multiple db connections

From: <bshah_at_sportsmail.com>
Date: Tue, 26 Sep 2000 21:35:25 GMT
Message-ID: <8qr4qt$gmu$1@nnrp1.deja.com>

Hi,

We need multiple database connections for a web-server like architecture. The program we are writing is in pro*c, and we wanted to know the best (considering both cost and efficiency) to set up the connection scheme.

Reading over the documentation, I see that we could use one common context, shared between threads/connections. However, this context may not be used by more than thread at a given time. This seems to be a big limitation if there are thousands of connections.

Another alternative I see is to have one context per thread/connection. Efficiency and cost wise, this seems really expensive. Are there any real advantages to this method?

What about not using a context at all? Instead, just having one user logged in and making queries. This seems to be a better solution than both the aforementioned. Is this a viable solution?

This seems like a common issue to web servers. How do they do it? Or is there another better solution?

TIA Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Sep 26 2000 - 16:35:25 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US