On Friday 14 November 2003 09:10, MB wrote:

> Daniel Aut wrote:
> > i could do a close connection after every commit, and a open conn
> > before beginning transaction, but in this way, the application will be
> > slower.
> >
> > What do you think?
>
> I do it all the time. It isn't that much slower. Try it, and see if it
> fits your users' definition of "slow".

IB5, IB6, possibly IB6.5, and Fb 1.0 to Fb 1.0.2 were all 'slow'. Due to a
coding error there was a built in delay of up to one second for each
connect. This has been fixed from Fb 1.0.3 onwards (and for IB, too, but I
can't remember when.)

So yes, there is an overhead in starting a new connection, but nothing like
there used to be.


Paul
--
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase