Subject | Re: [ib-support] Re: Canceling Queries |
---|---|
Author | lester@lsces.co.uk |
Post date | 2002-02-27T06:58:12Z |
> select rdb$start_time from rdb$requests;Claudio
>
> select rdb$request_id from rdb$requests
> where rdb$user = 'ROGUEUSER';
>
> delete from rdb$requests
> where rdb$request_id = 38;
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