pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Josh Berkus <josh@agliodbs.com>
To: pgsql-php@postgresql.org
Subject: Re: Help with timeouts
Date: Fri, 05 Oct 2001 08:26:43 -0700
Message-ID: <web-142387@davinci.ethosmedia.com> (raw)
In-Reply-To: <web-142030@davinci.ethosmedia.com>

Folks,

Some answers:

> I have a very complex database operation that can sometimes take
> 70-90
> seconds to return results. The web page which displays the results,
> however, seems to always timeout at 60seconds despite setting the
> Apache
> timeout to 300 seconds and set_time_limit to 240.

After a helpful web guru called us up from our post, we were able to
diagnose what's happening here (donation to be announced later):

Regardless of the Timeout and set_time_limit() settings, most browsers
will time out at 60 seconds.

This is obviously a huge annoyance. Therefore I am offering a *second*
charity prize to any person who can give me code (PHP or Perl) which
will display a "Processing" screen with an auto-reload to keep the
browser interested while waiting 60 to 120 seconds for a database
response in the background. *Someone* must have done this already, even
though multi-threading in PHP & Perl is nigh impossible.

-Josh Berkus







view thread (17+ messages)  latest in thread

Message-ID: <web-142387@davinci.ethosmedia.com>
Permalink:  ../web-142387@davinci.ethosmedia.com/
Also on:    postgresql.org/message-id/web-142387@davinci.ethosmedia.com

 · 

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: josh@agliodbs.com
  Subject: Re: Help with timeouts
  In-Reply-To: <web-142387@davinci.ethosmedia.com>
  References: <web-142030@davinci.ethosmedia.com> <web-142387@davinci.ethosmedia.com>

* 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