connection pool with php

[flafer]

Hi there,
i'm working on a platform Linux-RH-7.2 with a webserver using Apache + postgresql + php.
my question is (i want) to make a connection pool under php but i haven't got any idea.
do we need a class for that or is not possible under php?
Thanx in advance.

Regards,
Fatah

[zhabala]

I am not sure what you mean by connection pool. In PHP you can use pg_pconnect for so called persistent connection to the postgresql backend. Then in case some free conection exists, it uses it, otherwise it creates new one.

I know, that there are some problems with temp tables. You have to drop them explicitly, becase you can't be sure they are deleted at the end of connection.

Zdenek

[flafer]

what I mean by a connection pool is that, we have say 15 "open" connections in the pool and any client requesting a db connection will use one of the already open. if the client finishes with it, that connection still open and back to the pool for other clients request.

But in case of pg_pconnect, any client request for a db connection, the server will "open" a persistent connection which lead to delays if we have many clients requesting a connection in a same time.

so, i think pg_pconnect differs from a connection pool which already have a pool of open connections.

Fat.

[flafer]

Hi All,
Any one have experienced in php to open a connection pool (as explained in previous email).
I need it urgently.
Thanx in advance.

Fat.