Re: [Gnumed-devel] Re: low performance

[Karsten Hilbert]

> There is connection pooling for read-only connections.
> Transactions are committed at a *connection* level, a stupid limitation of 
> the 
> backend libraries. A connection does not allow isolated concurrent 
> transactions, and pooling writeable connections would require disciplined 
> formal release of the connection after the transaction has been completed.
> 
> Maybe we should have another look at SQL Relay.
"Most" queries will be read-only, IMO. And right now (where we
are experiencing slowness) we hardly have any writes yet. I
don't think it'll help too much at the moment to pool writing
connections. And it can be added transparently to gmPG fairly
trivially.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346