Re: [Gnumed-devel] Re: low performance

[Horst Herb]

On Mon, 7 Jun 2004 11:07, sjtan wrote:
> > Also, currently gnumed establishes a separate TCP connection for every
> > commit transaction,
> > a obvious and simple point for optimisation.
>
> I thought there was connection pooling.

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.

Horst