Click here to Skip to main content
Rate this: bad
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
Posted 19-Jan-13 5:07am

1 solution

Rate this: bad
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)
3. I believe having 1300 columns in table could be a sign that system design might need re factoring or optimization.
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.

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 240
1 CHill60 210
2 Zoltán Zörgő 170
3 Peter Leow 170
4 Richard Deeming 166
0 Sergey Alexandrovich Kryukov 9,248
1 OriginalGriff 6,806
2 Peter Leow 4,432
3 Zoltán Zörgő 3,919
4 Richard MacCutchan 2,782

Advertise | Privacy | Mobile
Web04 | 2.8.150129.1 | Last Updated 19 Jan 2013
Copyright © CodeProject, 1999-2015
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