Subject Re: [ib-support] Re: Canceling Queries
Author lester@lsces.co.uk
> select rdb$start_time from rdb$requests;
>
> select rdb$request_id from rdb$requests
> where rdb$user = 'ROGUEUSER';
>
> delete from rdb$requests
> where rdb$request_id = 38;

Claudio

This sounds too simple, is it a practical way forward?

It sounds as if it could give 'performance time' information
such as

select rdb$start_time, rdb$request from rdb$requests where
rdb$start_time > 'NOW' - (2mins)

I presume that the missing bit is getting the 'delete' to
actually cancel the query?

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