[V4MD] Multiple connections

[Ruslan Zasukhin]

on 9/3/03 4:46 PM, Lloyd Butler at lbutler at on.pelmorex.com wrote:

Hi Lloyd,

> In following this thread, it dawned on me. What counts as a server
> connection?

We name Database object = connection.

> If you have the connection timeout set long, and a client dies, but the
> cursor has not timed out, is that one connection not avialable from the
> pool?

Not correct. User can have one db object. This is one connection.
User can make then 5 cursors. But this is still ONE connection.

And if server drop that user on idle, then all his cursors are closed of
course.

I hope this explain your next questions also.

> So if you have the basic 5 connections, as a developer, we need to worry
> about those not quite timed out connections eating up our allowable
> connections.
> 
> Is there a way yet to get Vserver to flush all the idle connections before
> they are timed out? Most of the discussion so far seems to be from the
> client end asking to be reconnected. What if the client dies and doesn't
> come back? Is there a way to get the server to kill the connection before it
> times out? Not so much from the client end, but just to have that ability as
> a db admin to reset all connections without restarting the server.
> 
> There are cases where you would like to have a long time out as a safety
> net, but not want it to bite you in the butt at the same time in terms of
> stale connections.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------