Click here to Skip to main content
11,432,427 members (65,630 online)
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)



Advertise | Privacy | Mobile
Web04 | 2.8.150428.2 | 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