Subject Re: Can we, can we, can we????...
Author johnson_dave2003
--- In, "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
> > 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

> > A DBA monitor/kill is a prime example of a use for a memory only
> > table. Relatively few queries are likely to run concurrently
> > than a few thousand), the overheads of writing to DASD are
> > 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