From: | Tom Samplonius <tom(at)sdf(dot)com> |
---|---|
To: | Alain Toussaint <nailed(at)videotron(dot)ca> |
Cc: | PostgreSQL Hackers List <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Re: [NOVICE] Re: re : PHP and persistent connections |
Date: | 2000-11-26 18:58:34 |
Message-ID: | Pine.BSF.4.05.10011261054380.10023-100000@misery.sdf.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-novice |
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.
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.
Tom
From | Date | Subject | |
---|---|---|---|
Next Message | selkovjr | 2000-11-26 19:15:20 | Re: [HACKERS] Indexing for geographic objects? |
Previous Message | Peter Eisentraut | 2000-11-26 18:47:33 | Re: tcl/FreeBSD 4.2-STABLE, multiple TCL versions installed |
From | Date | Subject | |
---|---|---|---|
Next Message | fatboy2000 | 2000-11-26 21:37:11 | Postgres Date Format. |
Previous Message | Dmitri Touretsky | 2000-11-26 18:35:02 | One more simple question... |