From: | Chadwick Rolfs <cmr(at)shell(dot)gis(dot)net> |
---|---|
To: | Chris Ruprecht <chrup999(at)yahoo(dot)com> |
Cc: | PostGreSQL PHP Group <pgsql-php(at)postgresql(dot)org> |
Subject: | Re: pg_pconnect - ?? |
Date: | 2002-01-28 21:07:17 |
Message-ID: | Pine.SOL.3.96.1020128160529.25035E-100000@shell.gis.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-php |
Sorry, I guess you can disregard most of my reply:)
But a functiont that checks for connections and makes on only if one isn't
already there is still good idea, if you are making many queries in a
small amount of time.
Are you making many queries at once, or the same one many times, or
different ones quickly?
On Mon, 28 Jan 2002, Chris Ruprecht wrote:
> Ok, so from what I see on here, pg_pconnect doesn't have any
> advantages over pg_connect in my situation. I have the web server
> running on the same machine as the database server and yes, I have
> allocated 16384 shared buffers (at 8 KB each, this is 128 MB of
> shared memory). I have not noticed any connect overhead when opening
> a web page which connects to the database (99% of them do), the
> connection is instantaneously, so I guess, I don't need to do
> anything here.
> I was under the impression, that a persistent connection would open
> one and only one process which then will be used all the time without
> creating more child processes which keep lingering about. I guess, I
> was wrong here ...
>
> Best regards,
> Chris
> --
> Chris Ruprecht
> Network grunt and bit pusher extraordinare
>
> _________________________________________________________
> Do You Yahoo!?
> Get your free @yahoo.com address at http://mail.yahoo.com
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)
>
Chadwick Rolfs - cmr(at)gis(dot)net
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*--
From | Date | Subject | |
---|---|---|---|
Next Message | Mitch Vincent | 2002-01-28 21:12:27 | Re: pg_pconnect - ?? |
Previous Message | Chadwick Rolfs | 2002-01-28 20:50:54 | Re: pg_pconnect - ?? |