--- In Firebird-Architect@yahoogroups.com, "Dmitry Yemanov"
<dimitr@u...> wrote:

> "johnson_dave2003" <d_johnson@c...> wrote:
> >
> > If the the kill is implemented as Jim suggested, where a broken
> > connection terminates the query, then timeout can be implemented

at

> > the client side as a socket timeout. This put timeout under the
> > control of the application.
>
> What about embedded (and perhaps IPC) connections?

Oops! I tend to think of a database conection as always through a
socket. Bad me. (smack)

Embedded is a different beast. Users expect finer control of cancel
logic.

>
> > A DBA monitor/kill is a prime example of a use for a memory only
> > table. Relatively few queries are likely to run concurrently

(less

> > than a few thousand), the overheads of writing to DASD are

definitely

> > not desired, and if the server dies the data is garbage.
>
> It has already been discussed last year in fb-devel.

I'll have a look at these past discussions.

>
>
> Dmitry