Subject | Re: Canceling Queries |
---|---|
Author | Dimitry Sibiryakov |
Post date | 2002-02-28T04:00:47Z |
On 26 Feb 2002 at 5:07, Claudio Valderrama C. wrote:
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. ;)
SY, Dimitry Sibiryakov.
> I think that it could be useful to define a global quanta for request. IfHmmm... I don't like when an application does something,
> that quanta is reached, query is cancelled automatically.
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 toGreat, but, I'm afraid, this is offtopic here.
> 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;
SY, Dimitry Sibiryakov.