Received: from socrates.catalyst.net.nz (socrates.catalyst.net.nz [203.96.153.226]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g0F0g0V98785 for ; Mon, 14 Jan 2002 19:42:00 -0500 (EST) (envelope-from andrew@catalyst.net.nz) Received: from heidegger.catalyst.net.nz (hume.catalyst.net.nz [203.96.153.228]) by socrates.catalyst.net.nz (8.9.3/8.9.3/Debian 8.9.3-21) with ESMTP id NAA20848; Tue, 15 Jan 2002 13:42:01 +1300 X-Authentication-Warning: socrates.catalyst.net.nz: Host hume.catalyst.net.nz [203.96.153.228] claimed to be heidegger.catalyst.net.nz Received: from 127.0.0.1 (ident=unknown) by heidegger.catalyst.net.nz with esmtp (MasqMail 0.1.16) id 16QHfa-6Hh-00; Tue, 15 Jan 2002 13:41:42 +1300 Subject: Re: passing resource id's through functions From: Andrew McMillan To: "Brent R. Matzelle" Cc: pgsql-php@postgresql.org In-Reply-To: <20020114205415.69638.qmail@web13002.mail.yahoo.com> References: <20020114205415.69638.qmail@web13002.mail.yahoo.com> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Evolution/1.0 (Preview Release) Date: 15 Jan 2002 13:41:41 +1300 Message-Id: <1011055302.26843.27.camel@kant.mcmillan.net.nz> Mime-Version: 1.0 X-Archive-Number: 200201/19 X-Sequence-Number: 826 On Tue, 2002-01-15 at 09:54, Brent R. Matzelle wrote: > --- Culley Harrelson wrote: > > DBBalancer looks interesting. Looks like you are part of the > > development team with this project? What sort of performance > > difference to you see? When I made the decision to go with > > php/postgres as my primary development technologies I never even > > started using persistant connections because of all the mixed > > reviews. The database is local to the web server and performance > > is fine. I would be interested in hearing more about this > > connection pooling though... > > There is another connection pooling software piece that supports many > more databases that you might want to take a look at. It is called > SQL Relay and it works with PHP, C++, Perl, Java, etc: > > http://www.firstworks.com/sqlrelay.html SQL Relay looks pretty polished, but the problem I have in my case is that it requires me to go back and change my application a bit too much. The web page suggests it doesn't support PostgreSQL functions, for example, which I use extensively. I've spent all this time learning the PHP/PostgreSQL API, and writing my application to use it, I'm not going to go back and rewriet to use SQL Relay instead. DBBalancer is completely transparent to PHP - change your connect string (or not - you can make the change to your database server instead) and you are off. OTOH if I were developing a new site from scratch it would deserve much more consideration. Cheers, Andrew. -- -------------------------------------------------------------------- Andrew @ Catalyst .Net.NZ Ltd, PO Box 11-053, Manners St, Wellington WEB: http://catalyst.net.nz/ PHYS: Level 2, 150-154 Willis St DDI: +64(4)916-7201 MOB: +64(21)635-694 OFFICE: +64(4)499-2267 Are you enrolled at http://schoolreunions.co.nz/ yet?