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.



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/