pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Marco Colombo <marco@esi.it>
To: Francisco Reyes <lists@natserv.com>
Cc: pgsql-php@postgresql.org
Subject: Re: Long running queries and timeouts
Date: Mon, 21 Jan 2002 11:21:45 +0100
Message-ID: <200201211021.g0LALjR09061@Megathlon.ESI> (raw)
In-Reply-To: <20020120105039.V32376-100000@zoraida.natserv.net>
References: <20020120105039.V32376-100000@zoraida.natserv.net>

On Sunday 20 January 2002 16:56, Francisco Reyes wrote:
> On Sat, 19 Jan 2002, Chadwick Rolfs wrote:
> > 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?
[...]
> After someone suggested I looked at "set_time_limit" I found that such
> function doesn't account for DBconnection time. Afer reading that and your
> suggestion to read httpd.conf I am starting to think that the likely place
> of the timeout is the web server.
>
> Will play with the settings on httpd.conf
>
> I wonder how sites that display an update while the long query is running
> do it. I have seen sites that display something like "retrieving info..
> please wait" and then right before the info comes up the waiting text
> dissapears. Is that Javascript? Flash? I can't imagine how that could be
> done with plain html.

What timeout message do you get, exactly? I could be just the *client*, or
the HTTP proxy, that times out if your script doesn't produce any output,
and *not* the httpd process (thus, no need to look at httpd.conf).

.TM.



view thread (16+ messages)  latest in thread

Message-ID: <200201211021.g0LALjR09061@Megathlon.ESI>
Permalink:  ../200201211021.g0LALjR09061@Megathlon.ESI/
Also on:    postgresql.org/message-id/200201211021.g0LALjR09061@Megathlon.ESI

 · 

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: marco@esi.it, lists@natserv.com
  Subject: Re: Long running queries and timeouts
  In-Reply-To: <200201211021.g0LALjR09061@Megathlon.ESI>
  References: <20020120105039.V32376-100000@zoraida.natserv.net> <200201211021.g0LALjR09061@Megathlon.ESI>

* 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