Subject Re: [ib-support] Re: Canceling Queries
Author lester@lsces.co.uk
> > Unlike IB5, in IB6 it works pretty good, (provided you are connected via
> tcp/ip)
> > i.e. server will notice that the client is dead and cancels
> > execution of query (even if it is in the middle of sorting).
>
> I didn't know about this, and it's a big help. Is it documented in some
> place? It's enough to kill the connection and connect again?

I view this as one of the MAJOR bugs in IB5.X which was
fixed in IB6. My problem was ( and still is ) flaky network
connections. On IB5 the server end connections just stacked
up until the server went belly up, unless you did a
stop/start to clear things down regularly. With IB6, never
seen that problem.

Deliberate 'kills' of a process are just the same thing.

I think it is documented on the closed bug list - but stand
to be corrected.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services