Bill:

The question is: should this new feature be the reason to delay Version 1
release?

I think we all agree that this feature should be a must in the future. I
will go further in here: Some way to get a list for all queries that are
running on the server and kill them will be very useful, or even the server
to stop the query automatically when the connection is drop by the client,
or give the query some timeout.

(Do you think your users will stop that queries anyway? I vote on something
like 'Uau! I did a 'simple query' to get some really important values that I
need for my report and I'm waiting for it for hours! Can you imagine!?)

And my half a cent to this discussion.

(I think this will not be a discussion: the Firebird Team point already that
there will be no 'new features' on release 1.)

Artur

----- Original Message -----
From: "Bill Morrison"
To: <ib-support@yahoogroups.com>
Sent: Tuesday, February 26, 2002 3:37 PM
Subject: RE: [ib-support] Re: Canceling Queries


> I have to disagree. As most of my production databases run into the 100's
of
> gigs, and users being what they are, I've had users do a query that will
> start returning records about the same time that our Sun finally fizzles
out
> into a chunk of charcoal (slight exaggeration).
>
> Thus it *would* be nice to allow them to cancel the query at that point.
>
>
> Just my two cents worth.
>
>
> Bill M
>
> -----Original Message-----
> From: Dimitry Sibiryakov [mailto:SD@...]
> Sent: Monday, February 25, 2002 10:33 PM
> To: ib-support@yahoogroups.com
> Subject: RE: [ib-support] Re: Canceling Queries
>
>
> On 26 Feb 2002 at 13:07, Sandeep wrote:
>
> > I think it should be included in first release of FB, as some queries
> > could take very long to execute.
>
> I don't think so. Of course, possibility to cancel long
> queries is nice but not very useful. If you run a wrong
> query against your debug database... Well, shutdown the
> server. If somebody runs a long query against a work
> database... This person, definitely, wants results and
> cancelling the query doesn't make sense. If the person
> doesn't want results... Hmm... Kick this good-for-nothig
> person's ass and shutdown the server ( ;) ), because you
> can't cancel other's query anyway.
> Much more useful could be a way to see queries, running
> on the server and to cancel any of them.
>
> SY, Dimitry Sibiryakov.
>
>