Re: passing resource id's through functions

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



Yes, that's it.  Using the $GLOBALS array works just fine, and I don't
have a bunch of pconnections cluttering up the process list, apache, or
postgresql.  I don't think persistent connections are meant to be _faster_
as much as they are meant for cutting down on redundant connections.
Unfortunately, I'm getting a bunch of redundant connections when pconnect
is used.  Since I don't administer the server, and the ones who do are too
busy to experement, I'll have to deal with it.  I'd like to know if
anyone else is having the same problem with pconnect:

pg_pconnect is in ONE file referred to by all of my other files.  So there
is only one connect string.  It can't change unless I edit the connection
file between invocations (let's just say it's STATIC)

when I go to pg_exec with the pg_pconnect resource, I get a seperate
connection for each exec!  This is clearly not supposed to be the case
acoording to http://www.php.net/manual/en/function.pg-pconnect.php

setting apache to only accept a certain amount of links is a good work
around, but what about everyone else?  Won't my connections just get
kicked off if other pconnections take over?  when I look at the postgres
processes, I should see _ONE_ persistent connection, not nine

The max conncection set is 64, so that won't be a problem, except that
each persistent connection takes a little bit of memory (2.5%), and enough
of them will actually slow the sever down.

Thanks for the great suggestion on using php's global namespace!

Regards,

On 12 Jan 2002, Andrew McMillan wrote:

> On Sat, 2002-01-12 at 04:44, Chadwick Rolfs wrote:
> > I seem to have figured out that pg_connect returns a resource ID that will
> > not pass into another function, and that pg_pconnect does.  I'm not too
> > 
> > Any help would be appreciated, and helpful :)
> 
> It might be that I don't see any difference because connecting to the
> database(s) is something I do globally, rather than inside a function,
> or through instantiating an object.

Chadwick Rolfs - cmr@xxxxxxx
Cleveland State University - Student
Music Major - The Holden Arboretum Volunteer
Computer Programmer - Student Employee
--*I finally found powdered water;
I just can't figure out what to add to it*--



[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux