Bruce Momjian wrote:
> Yes, that is assuming you are using PHP. If you are using something
> else, you connection pooling in there too. All those client interfaces
> reimplementing connection pooling seems like a waste to me.
Effective pooling's pretty specific to your environment, though, so any
general mechanism would have to provide a wide-ranging suite of
parameters governing the number to pool, how long each handle should
live, what to do if a handle's released by a client while in the midst
of a transaction (AOLserver rolls back the transaction, other clients
might want to do something else, i.e. fire a callback or the like), etc etc.
I think it would be fairly complex and for those high-throughput
applications already written with client-side pooling no improvement.
And those are the only applications that need it.
--
Don Baccus
Portland, OR
http://donb.photo.net, http://birdnotes.net, http://openacs.org