X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 82452D1C91A for ; Tue, 5 Aug 2003 19:42:31 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 35047-03 for ; Tue, 5 Aug 2003 16:41:13 -0300 (ADT) Received: from smtp.electroniccity.org (smtp.electroniccity.org [207.219.15.18]) by svr1.postgresql.org (Postfix) with ESMTP id D7F45D1C91F for ; Tue, 5 Aug 2003 16:42:20 -0300 (ADT) Received: from [172.16.2.153] (d2-153.electroniccity.org [172.16.2.153]) by smtp.electroniccity.org (Postfix) with ESMTP id EA03CDF21A for ; Tue, 5 Aug 2003 15:36:34 -0500 (EST) User-Agent: Microsoft-Outlook-Express-Macintosh-Edition/5.02.2022 Date: Tue, 05 Aug 2003 15:45:33 -0400 Subject: Re: PHP Connections From: Lynna Landstreet To: Message-ID: In-Reply-To: Mime-version: 1.0 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200308/9 X-Sequence-Number: 2186 on 8/5/03 3:07 PM, scott.marlowe at scott.marlowe@ihs.com wrote: > On Tue, 5 Aug 2003, Lynna Landstreet wrote: > >> But hey, come to think of it, maybe I could turn the pg_connect into a >> pg_pconnect and just have it check to see if $db already exists before >> connecting - that way there'd be only one connection per site visit! Cool, >> your question gave me a new idea... :-) > > Be VERY wary of persistant connections. They are fraught with danger and > can cause your server to present the "too many connections" error message > after being up for a while. Hmmm, OK. I didn't realize they didn't time out. Maybe it's best to leave it the way it is now, with just one pg_connect being called in the head of each document. Thanks. Lynna -- Resource Centre Database Coordinator Gallery 44 www.gallery44.org