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