From: Ellen K. 

I have 600-and-something users on each of my databases.  They are making
transactions all day.

On Mon, 23 May 2005 11:44:37 +0100, Adam
 wrote in message
:

>Ellen K. wrote:
>
>> I guess the new system will use connection pooling but what we have now
>> with our SQL Servers is the user's connection is created when s/he first
>> logs in, and persists until s/he logs off.  This is contrary to the
>> Received Wisdom but works great.
>>
>
>Fine & works great in many circumstances (esp low number of users (e.g.
>some system / "DBUser" users)). Not so great if you have a web app
>thingy with lots of users each of which must be a DBUser given people
>just close their browser & thus the web app has no real way of knowing
>(http is connectionless/stateless) if the connection can be
>closed/returned to the pool
>
>Horses for courses.
>
>Adam

--- BBBS/NT v4.01 Flag-5