2. PHPRunner General questions
  3. Fatal error - timeout
This topic is locked

Fatal error - timeout

 		3/28/2009 6:45:13 PM
PHPRunner General questions
F
 ftoth author

I have two inner joins on three tables in the database. Database tables having large number of records.

I am getting the following error. Is there a way of extending the max execution time ? or speeding up the query ?
Fatal error: Maximum execution time of 60 seconds exceeded in C:\Documents and Settings\My Documents\PHPRunnerProjects\Project1\output\include\dbconnection.php on line 32
Any suggestion is appreciated.
Admin 3/30/2009

You can change max_execution_time variable value in php.ini.

You can also use set_time_limit() function in your code to override default value.
More info: http://us.php.net/set_time_limit
A
 		alang 3/30/2009

Setting appropriate indexes on the database tables can also make a significant difference. See http://www.asprunner.com/forums/index.php?showtopic=6244
S
 		swanside 3/31/2009

I get this aswell, and we only have 20K records on our system, but I do have smoe large MySQL calculations going on.
Most of the time, I get this error when trying to export, I put my mas_execution in the php.ini file from 30 to 300, and all it does is takes longer for the timeout error.
Will need to read abit more on MYSQL.