pg.ddx.io pgsql-php@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Chadwick Rolfs <cmr@shell.gis.net>
To: Francisco Reyes <lists@natserv.com>
Cc: pgsql-php@postgresql.org
Subject: Re: Long running queries and timeouts
Date: Sat, 19 Jan 2002 12:32:46 -0500 (EST)
Message-ID: <Pine.SOL.3.96.1020119122652.18364B-100000@shell.gis.net> (raw)
In-Reply-To: <20020119114634.R30681-100000@zoraida.natserv.net>
On Sat, 19 Jan 2002, Francisco Reyes wrote:
> New to the PHP/PostgreSQL combo.
> I have a couple of queries which take a few minutes to run and we are
> getting timeouts. Didn't find anything usefull on the archives.
>
> How are you handling long running queries on your PHP?
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
You can always use persistent connections. It's not a good idea to use
too many, or you will be denied access to Postgres any other way, but it's
a quick fix for the short run.
Long run and responsibility includes using an array, or an object to
retrieve data. You can always split queries up into many small queries.
We'll need a little more information to help you with that, though. Like
what the code is...what your php.ini file and httpd.conf file says about
connection timeouts... maybe more ??-- like what you've read on php.net's
docs...
When new programmers here where I work started using php/postgresql 6
months ago, they used pconnect in EVERY one of their scripts, filled up
the server, and were unable to connect. No one was able to. They didn't
know what they did, and it took a little reading to figure out that Apache
needs to be restarted, NOT postgres. Don't kill -9 the postmaster.
Regards,
Chadwick Rolfs - cmr@gis.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*--
view thread (16+ messages) latest in thread
Message-ID: <Pine.SOL.3.96.1020119122652.18364B-100000@shell.gis.net> Permalink: ../Pine.SOL.3.96.1020119122652.18364B-100000@shell.gis.net/ Also on: postgresql.org/message-id/Pine.SOL.3.96.1020119122652.18364B-100000@shell.gis.net ·
reply
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Reply to all the recipients from your mail client; the link fills in the headers below: reply via email Some clients, webmail especially, drop In-Reply-To and References from a link, and the reply then starts a new thread: use the mbox below. To: pgsql-php@postgresql.org Cc: cmr@shell.gis.net, lists@natserv.com Subject: Re: Long running queries and timeouts In-Reply-To: <Pine.SOL.3.96.1020119122652.18364B-100000@shell.gis.net> References: <20020119114634.R30681-100000@zoraida.natserv.net> <Pine.SOL.3.96.1020119122652.18364B-100000@shell.gis.net> * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox