From: | "Raymond O'Donnell" <rod(at)iol(dot)ie> |
---|---|
To: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: Connections sitting idle... |
Date: | 2002-12-10 14:14:15 |
Message-ID: | 3DF5F6B7.6203.5DB4E52@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
On 10 Dec 2002 at 13:53, Dave Page wrote:
> I think its 40K (iirc). Can you zip/gzip the files?
Ah! - that would do it. Zipped files are attached, and the original
covering email follows.
--Ray.
--------------------
I've attached two logs: the "single instance" one was generated by
clicking my way through the web app in a single browser window, while
the
other was generated from three different browser windows at the same
time.
With three copies of the app running, I had at times nine idle
backends on the database machine, which as far as I could tell hung
around for about 80s each - I times two or three at random, and the
rest seems subjectively to last about the same amount of time. This
was with connection pooling turned *on* - no obvious reuse of
connections - each page opened a new connection, even though the
connection parameters are the same every time.
This machine was running Windows Me and Personal Web Server. I'll be
trying it out on a Win2K machine in the morning.
--Ray.
-------------------------------------------------------------
Raymond O'Donnell http://www.galwaycathedral.org/recitals
rod(at)iol(dot)ie Galway Cathedral Recitals
-------------------------------------------------------------
Attachment | Content-Type | Size |
---|---|---|
logs.zip | application/zip | 5.8 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Simeó Reig | 2002-12-10 20:03:39 | Re: kill 'zombies' |
Previous Message | Dave Page | 2002-12-10 13:53:40 | Re: Connections sitting idle... |