Zeoslib Portal

Hi,

Does Zeos support connection pooling (especially on postgres, but not limited to) ? If so can someone explain how can I configure my ZConnections (running in different threads) to use the pool? thank.

Hello stoffman,

Zeos supports using connection pools. This are a different driver though. If you want to pool your connection, use "pooled.postgres". Connections will be pooled from there.
But the base principle for threads in Zeos still applies there: one conenction may only be used in one thread at the same time. Zeos is not thread safe beyond that.

Best regards,

Jan

Hi Jan,

I'm not sure what you mean by use "pooled.postgers" (I'm really new to zeos)

The only thing that resemble your suggestion is the protocol property in ZConnection that has: "pooled.*" value

"pooled." is a prefix, not a standalone protocol. If you need a pooled connection of "mysql" protocols, enter "pooled.mysql"; if you need "oracle", enter "pooled.oracle" and so on.

Thanks.