Subject Re: Canceling Queries
Author Dimitry Sibiryakov
On 26 Feb 2002 at 5:07, Claudio Valderrama C. wrote:

> I think that it could be useful to define a global quanta for request. If
> that quanta is reached, query is cancelled automatically.

Hmmm... I don't like when an application does something,
what I haven't asked for. This is the ... MS' way. :) I can
understand that garbage collection is performed
automatically, but I can't tolerate if "this stupid box"
cancels my request! I want to be able to change this
"quanta" for MY queries to infinity. ;)

> Now, for your feature, we could have a virtual system table do to
> interesting things:
>
> 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;

Great, but, I'm afraid, this is offtopic here.

SY, Dimitry Sibiryakov.