At 10:54 PM 15-09-01 -0400, Doug Chamberlin wrote:

>I would define an object (a singleton factory object) from which each
>transaction gets a connection. This request of the factory would normally
>be done just before the transaction is started. I presume you can find the
>right place to add this.
>
>That connection factory returns an unused one if it has one on hand or
>otherwise creates a new connection. Internally it keeps a list of
>connection references which are available and currently unused.

The TIB_Connection class in IB Objects v. 4 provides this pooling architecture.

rgds,
Helen

All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________