From: | Ron Chmara <ron(at)Opus1(dot)COM> |
---|---|
To: | Tom Samplonius <tom(at)sdf(dot)com> |
Cc: | Alain Toussaint <nailed(at)videotron(dot)ca>, PostgreSQL Hackers List <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Re: [NOVICE] Re: re : PHP and persistent connections |
Date: | 2000-11-27 07:56:03 |
Message-ID: | 3A221384.DC7AE01D@opus1.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-novice |
Tom Samplonius wrote:
> On Sun, 26 Nov 2000, Alain Toussaint wrote:
> > > "I have all sorts of client apps, connecting in different ways, to
> > > my server. Some of the clients are leaving their connections open,
> > > but unused. How can I prevent running out of backends, and boot
> > > the inactive users off?"
> > how about having a middle man between apache (or aolserver or any other
> > clients...) and PosgreSQL ??
> I don't see it solving anything. You just move the connection
> management problem from the database to the middleman (in the industry
> such a thing would be called a query multiplexor). Multiplexors have
> often been used in the past to solve this problem, because the database
> could not be extended or protected.
And I'm requesting protection. Because the database isn't capable of dynamically
detroying temporary backends. (Which would be another solution to this
problem)
> Besides, if you are an n-tier developer, this isn't a problem as your
> middle tier not does connection management, but some logic as well. At
> the end of the day, PHP/Apache is just not suitable for complex
> applications.
Is it dump on PHP day?
Okay, pretend the problem is left-open Perl connections. Slam that for
a while. Move over to left open Access connections. Bag on that for
a few posts. Errant C code for a few days. Still have a problem. :-)
How does a db admin close connections that are idle, and unwanted, without
shutting the postmaster down?
-Bop
--
Brought to you from iBop the iMac, a MacOS, Win95, Win98, LinuxPPC machine,
which is currently in MacOS land. Your bopping may vary.
From | Date | Subject | |
---|---|---|---|
Next Message | Karel Zak | 2000-11-27 10:09:30 | Re: OK, that's one LOCALE bug report too many... |
Previous Message | Ron Chmara | 2000-11-27 07:38:46 | Re: Re: [NOVICE] Re: re : PHP and persistent connections |
From | Date | Subject | |
---|---|---|---|
Next Message | Don Baccus | 2000-11-27 15:18:48 | Re: Re: [NOVICE] Re: re : PHP and persistent connections |
Previous Message | Ron Chmara | 2000-11-27 07:38:46 | Re: Re: [NOVICE] Re: re : PHP and persistent connections |