Subject Re: [IBO] execute SQL statement in new thread
Author Mihai Chezan
--- In IBObjects@yahoogroups.com, "Matej Golob" <matej.golob@e...>
wrote:
> > each thread should have it's own connection and transaction
> > Alan
> So I "loose" connection time (to make connection alive) on every
> thread execute?
>
> Matej
If you start many threads then you should make some kind of connection
pooling (meaning you make a cache of connections and when a thread
needs a connection you just give one from the conneciton pool and when
the thread finishes it will return the connection to the connection
pool).