This topic is locked

Database Timeout

12/8/2011 7:27:03 PM
PHPRunner General questions
D
DigitalDean8 author

Hopefully someone can help me with this issue. I have a project that stores very large video files, some up to 1gb or larger. My issue is that the DB connection seems to be timing out. I am running PHPR 5.3 and MySQL. I have set the PHP session timeouts but the DB seems to be timing out at 1200 seconds regardless of what I do with this error:
[08-Dec-2011 15:55:46] PHP Fatal error: Maximum execution time of 1200 seconds exceeded in C:\xampp\htdocs\LillyStories\assets_add.php on line 2
Line 2 of that php file references this line: include("include/dbcommon.php");
I looked at dbcommon.php but don't see any timeout referenced there.
Can anyone help me with how to set a longer execution time to allow these longer uploads?
Thanks

Dean

C
cgphp 12/9/2011

Store the video file in the database only as reference (a link where the file is located on the file system) not as blob. This is a debatable topic and the answer would depend on your circumstances, but if performance is a feature then storing it on filesystem is a better option.

T
TangoDog 12/9/2011



Hopefully someone can help me with this issue. I have a project that stores very large video files, some up to 1gb or larger. My issue is that the DB connection seems to be timing out. I am running PHPR 5.3 and MySQL. I have set the PHP session timeouts but the DB seems to be timing out at 1200 seconds regardless of what I do with this error:
[08-Dec-2011 15:55:46] PHP Fatal error: Maximum execution time of 1200 seconds exceeded in C:\xampp\htdocs\LillyStories\assets_add.php on line 2
Line 2 of that php file references this line: include("include/dbcommon.php");
I looked at dbcommon.php but don't see any timeout referenced there.
Can anyone help me with how to set a longer execution time to allow these longer uploads?
Thanks

Dean


You can set the time limit in the PHP ini file if you are using XAMP ... just look for the value max_execution_timeand set it to some big value;

The danger though is that a poorly written script cripples the server....