2. PHPRunner General questions
  3. [SOLVED]  Fatal error: Maximum execution time of 30 seconds exceeded
This topic is locked
[SOLVED]

 Fatal error: Maximum execution time of 30 seconds exceeded

 		5/4/2007 6:33:56 AM
PHPRunner General questions
D
 dcrera author

Hi,
In Step 4/12 I have a simple join with 2 tables referencing indexed fields and I get the following message :
Fatal error: Maximum execution time of 30 seconds exceeded in C:\Program Files\PHPRunner3.1\projects\mydas\output\include\dbconnection.php on line 36
Help !!
Admin 5/4/2007

Hi,
when and where did you get this error ?
D
 		dcrera author 5/9/2007

Hi,
The query took 40 secs to retreive the records in Oracle SQL Plus hence the 30 seconds time out in PHPrunner.
However I have since improved the response time to 1 second by using hints /+ USE_NL (a, <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=17753&image=1&table=forumreplies' class='bbc_emoticon' alt='B)' /> /

running in Oracle SQL Plus but I am still getting the same message 'Maximum execution time .... exceeded' in Phprunner.
Does Phprunner supports hints ?
Please help.
Thanks

Hi,

when and where did you get this error ?
Admin 5/9/2007

PHPRunner doesn't need to understand hints as PHP page simply passes SQL query to the database.
In general any query will work slower executed via PHP than using native client.
Take a look at set_time_limit() function to increase execution time limit:

http://us.php.net/set_time_limit