[Zope] Oracle or PostGreSQL connection pool

[Michel Pelletier]

> -----Original Message-----
> From: Nemeth Miklos [mailto:nemeth@iqsoft.hu]
>
>
> Do the Oracle or PostgreSQL database adapters and the ZSQL technology
> support connection pooling?

Oracle Yes, PostgreSQL is not written by DC so I don't know.  I suspect
yes.

> If I create a connection object, supposedly it may only be used by a
> single thread.

Not on Oracle.  The Oracle DA is fully concurrent.  Postgres, I don't
know.  Possible not.  Note that if a DA is not concurrent it's not
Zope's fault, it's usually because the client libraries to interface
that database are not concurrent.

> I'd like to use ZSQL methods but my application should be very
> concurrent.

Then stick with Oracle.

-Michel