Click here to Skip to main content
Sign Up to vote bad
good
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:07


1 solution

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ő - 19 Jan '13 - 15:59
Good points, my 5!
Sergey Alexandrovich Kryukov - 20 Jan '13 - 1:34
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
Your Filters
Interested
Ignored
     
0 OriginalGriff 315
1 Aarti Meswania 250
2 Slacker007 240
3 Sergey Alexandrovich Kryukov 219
4 Ron Beyer 190
0 Sergey Alexandrovich Kryukov 8,743
1 OriginalGriff 7,124
2 CPallini 3,678
3 Rohan Leuva 3,011
4 Maciej Los 2,403


Advertise | Privacy | Mobile
Web03 | 2.6.130516.1 | Last Updated 19 Jan 2013
Copyright © CodeProject, 1999-2013
All Rights Reserved. Terms of Use
Layout: fixed | fluid