Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: PHP
Hi friends
 
i have nearly 1300 columns in a table so when data entered and run my application i got this error
 
Fatal error: Maximum execution time of 30 seconds exceeded in G:\xampp\htdocs\GVA5-raj\business-income-expensed.php on line 39
 

i have changed in php.ini max_execution_time = 360 eventhough getting same problem
 
please give a solution for this
 

 
Thanks & Regards
 
Mallesh
Posted 19-Jan-13 5:07am

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

1. Have you checked phpinfo(); that all parameters have been actually changed?
 
2. In addition you can try to amend time limit at runtime
 
if (function_exists("set_time_limit") == TRUE AND ini_get("safe_mode") == 0)
{
    set_time_limit(300);
}
 
3. I believe having 1300 columns in table could be a sign that system design might need re factoring or optimization.
  Permalink  
Comments
Zoltán Zörgő at 19-Jan-13 15:59pm
   
Good points, my 5!
Sergey Alexandrovich Kryukov at 20-Jan-13 1:34am
   
All points are good, but the last one is critically important: not only I see no reason to risk exceeding the limitation of the script runtime, but I'm pretty much sure that nothing can possibly justify so much data shown at once: I cannot imagine a user who would really want to watch this crazy volume. The key to the solution is not the blunt performance but proper UI design: navigation, query, etc.
My 5.
—SA

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 DamithSL 390
1 Maciej Los 217
2 OriginalGriff 213
3 BillWoodruff 135
4 Garth J Lancaster 90
0 OriginalGriff 7,953
1 DamithSL 6,139
2 Sergey Alexandrovich Kryukov 5,449
3 Maciej Los 5,293
4 Kornfeld Eliyahu Peter 4,539


Advertise | Privacy | Mobile
Web02 | 2.8.141223.1 | Last Updated 19 Jan 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100