pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / 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