At 07:43 PM 2/02/2004 +0100, you wrote:

> I remember that firebird polls
>each connection every few (180?) seconds to make sure the client is still
>there

Yep, but only an inactive connection. From the POV of the server, if it is
still running a query for a connection or has unfetched rows waiting for
the connection, the connection is still there.

So, even when we get the ability to stop a runaway query, you will still
have your problem if you are writing applications that return a gazillion
records in bufferloads of 18 for your beloved DBGrid interface.

That is why, on the eighth day, God created the WHERE clause.

/heLen