Subject Re: [firebird-support] Query Time Out !!!
Author unordained
Last I knew, Firebird didn't have a feature allowing you to kill a query. You can kill a connection
(particularly by killing the client program) but that doesn't seem to always do it. You can restart
the server, of course ... Helen mentioned something about not wanting to allow connections to tell
the server to stop sending a result-set stream, though I think there have been positive comments
about allowing transactions and statements to be killed, at some point in future versions.

Until you have the ability to kill a query at random, it won't make much difference whether or not
you have a method of timing it.

But just FYI, you -can- find out how long your queries are currently (successfully) taking by
timing them yourself, or running them in, say IBConsole and looking at the "statistic" tab to see
how long it took.

-Philip

---------- Original Message -----------
From: Kiran Kumar Kurapaty <kiran.kurapaty@...>
To: "'firebird-support@yahoogroups.com'" <firebird-support@yahoogroups.com>
Cc: "'indug@yahoogroups.com'" <indug@yahoogroups.com>
Sent: Mon, 12 Apr 2004 13:22:02 +0530
Subject: [firebird-support] Query Time Out !!!

> Hi Frens,
>
> How do I find Query execution time? I want to stop the query execution If it takes more
> than the specified time... how do I achieve this ? can anybody thro some light on it..
>
> waiting for your feedback.
>
> Kiran Kurapaty.
>
> [Non-text portions of this message have been removed]
>
>
> Yahoo! Groups Links
>
>
>
------- End of Original Message -------