once solution might be to fork a process and send that to run the sql with
some big time out limit on it...then create the report save it as a file and
email to the user when complete
see http://ca.php.net/manual/en/function.pcntl-fork.php
Bastien
From: Cosman CUSCHIERI <[EMAIL PROTECTED]>
To: <php-db@lists.php.net>
Subject: [PHP-DB] RE: php-db Digest 20 Jun 2005 23:54:37 -0000 Issue 2992
Date: Wed, 22 Jun 2005 15:29:47 +0200
I make part of a team where we have created a system which produces
reports.
The reports are produced based on selection criteria which the user sets
from an oracle database.
The problem we are facing is that when the users selects a big time frame
the report just freezes, the status bar displays 'done' the IE (our
preferred browser) window flag stops animating and report does not show
anything, only a blank page. I am suspecting a time out somewhere. I am
using the function set_time_limit and some of the reports did improve but
still facing the problem with others.
Each report has a main SQL based on which the report is generated. I am
guessing setting set_time_limit prolongs the timeout of the generation of
the report by php, but i am suspecting, either:
1 - The sql is taking too much time to get back with some data on
which php will still time out.
2 - Some other time out exists (e.g. Apache).
if so 1 can somebody advice how to set this other time out if it exists or
some other way to workaround this.
if so 2 do somebody knows how to override this through php or some other
way
to workaround this.
Any feedback / ideas are very much welcomed
Cosman
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php