I am facing an issue with uploading an excel data sheet. The functionality is like
- User uploads an excel sheet
- Records are inserted into that custom component's tables by which graphs are shown in front-end. The tables contains all the calculation values for different years.
- Then, for those records categories and articles are created.
But this works fine for small data sheets containing nearly 200 rows. Sometimes, step (2) works and it gets stuck in step (3). And sometimes, nothing works. When a sheet consists of more than 2000 rows then, half data is inserted and it gives me this error:
Gateway Timeout - 504 error
I am using phpexcel
for uploading excel to database and tried setting the following in the controller's upload task but still it is not working.
ini_set('display_errors', 1);
error_reporting(E_ALL);
ini_set('max_execution_time', 1800); //also tried set_time_limit(0);
ini_set('memory_limit', '-1');
Kindly, guide to any solution