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 4: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 Sergey Alexandrovich Kryukov 338
1 _Amy 290
2 Maciej Los 260
3 Manfred R. Bihy 200
4 OriginalGriff 195
0 OriginalGriff 7,445
1 Sergey Alexandrovich Kryukov 6,347
2 Maciej Los 3,799
3 Peter Leow 3,558
4 CHill60 2,702


Advertise | Privacy | Mobile
Web03 | 2.8.140721.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