What takes time is the deallocation of statement handles.
Look at the property on the TIB_Connection.CacheStatementHandles and set it
false.
(Hope I spelled it right.)

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "paultansit" <paul@...>
To: <IBObjects@yahoogroups.com>
Sent: Wednesday, November 27, 2002 5:19 PM
Subject: [IBO] Quicker disconnect


> Does anyone know how to get a connection to close quickly? Even with
> no open transactions, it sometimes takes 5-10 seconds for IBO or
> Interbase to release a DB connection. The app will hang there
> waiting.
>
> What I have noticed is that in design mode, I can toggle the
> connection on and off, and sometimes it is instant, and sometimes it
> takes a few seconds to disconnect.
>
> I also found that if I end the app by using reset in the Delphi IDE
> that the connection always kills instantly.
>
> Is there some way to "force" the disconnect in the onclose event of
> the form?
>
> This is not really a problem, it's more of an annoyance.
>
> Thanks,
> Paul