[Zope] RE: Oracle or PostGreSQL connection pool

Oleg Broytmann phd@phd.russ.ru
Thu, 20 Jan 2000 12:21:53 +0000 (GMT)


Hi!

   Thanks for the discussion. It certainly make sense to discuss with DB
programmers.

On Thu, 20 Jan 2000, Anthony Baxter wrote:
> More importantly, this _won't_ scale. If I have 20 users, that will be 20
> connections held open. Yuk. And say I want to open 2 or 3 connections per
> user, to remove the single-threaded nature of it, and it's way way worse.

   I asked, and he replied: "I don't care about 20, even 200 connections".
He works with Oracle at least 3-4 years, and I worked for about a week, so
I better do not give him any advice :)

> &c &c &c.  Aside: if you're using ZOracleDA to talk to Oracle, and for
> some reason your Oracle connection gets trashed - restart Zope. Don't
> bother trying to just close and re-open the connection, I've found that
> leads to a world of pain. It sometimes works. And other times it makes
> bad things happen.

   Bad news :( Thanks.

> (I'm also somewhat unconvinced that Oracle's all that secure - would you
> expose an Oracle server to the internet? I don't think so... :)

   Certainly NO!

Oleg.
---- 
    Oleg Broytmann      Foundation for Effective Policies      phd@phd.russ.ru
           Programmers don't die, they just GOSUB without RETURN.