From: Mitch Vincent <mitch@doot.org>
To: pgsql-php@postgresql.org
Subject: Re: Long running queries and timeouts
Date: Sat, 19 Jan 2002 17:10:15 -0700
Message-ID: <004601c1a146$d6a58940$0200000a@Mitch> (raw)
References: <Pine.SOL.3.96.1020119122652.18364B-100000@shell.gis.net>
http://www.php.net/manual/en/function.set-time-limit.php will allow you to
set the timeout but you might post the queries and EXPLAIN output to
pg-general to see if there is something that can be done to speed them up...
Some well placed indexes always help!
> 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.
The maximum connections is a configuration parameter in postgresql.conf --
persistent connections are pretty cool but have been broken until recent
versions of PHP so I'm still hesitant using them..
> Long run and responsibility includes using an array, or an object to
> retrieve data.
Huh?
>You can always split queries up into many small queries.
What makes you say that?
-Mitch
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: mitch@doot.org
Subject: Re: Long running queries and timeouts
In-Reply-To: <004601c1a146$d6a58940$0200000a@Mitch>
References: <Pine.SOL.3.96.1020119122652.18364B-100000@shell.gis.net> <004601c1a146$d6a58940$0200000a@Mitch>
* 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