Re: [PHP-DB] RE: php-db Digest 20 Jun 2005 23:54:37 -0000 Issue 2992. .
Cosman CUSCHIERI wrote: 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. [snip] Make sure php is logging its errors somewhere, and check your apache error logs. This seems very much like the behavior I've seen when a script hits the maximum memory allowed. It's possible the first bottleneck was the processing, and the second is the memory needed. Of course, it's possible it's something else entirely - but something should be logged when the pages bail out like that. cheers, -- - Martin Norland, Sys Admin / Database / Web Developer, International Outreach x3257 The opinion(s) contained within this email do not necessarily represent those of St. Jude Children's Research Hospital. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
RE: [PHP-DB] RE: php-db Digest 20 Jun 2005 23:54:37 -0000 Issue 2992
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 - 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
