Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Multiple db connections
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