Re: Help with timeouts

Hello,

from the PHP manual:
"
Note: The set_time_limit() function and the configuration directive
max_execution_time only affect the execution time of the script itself. Any
time spent on activity that happens outside the execution of the script such
as system calls using system(), the sleep() function, database queries, etc.
is not included when determining the maximum time that the script has been
running.
"

So is there anything you forgot to mention ;)
I mean everything works fine except this query or you couldn't test the page
without the result.

Have you tried to optimize this query?
Maybe post to this list and wait for some suggestions...

----- Original Message -----
From: "Josh Berkus" <josh(at)agliodbs(dot)com>
To: <pgsql-php(at)postgresql(dot)org>
Sent: Friday, October 05, 2001 1:12 AM
Subject: [PHP] Help with timeouts

> Folks,
>
> 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.
>
> My client is going berserk. $50 (USD) to the non-political charity of
> your choice if you can give me a suggestion that works.
>
> SuSE Linux 7.2
> PostgreSQL 7.1.2
> PHP 4.0.3
>
> -Josh Berkus
>
>
>
> ______AGLIO DATABASE SOLUTIONS___________________________
> Josh Berkus
> Complete information technology josh(at)agliodbs(dot)com
> and data management solutions (415) 565-7293
> for law firms, small businesses fax 621-2533
> and non-profit organizations. San Francisco
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo(at)postgresql(dot)org)