Phpexcel Times Out

Yii 1.1 General Discussion
1

Hi,

I am using PHPExcel for exporting data from oracle db… i have these

options of date range to choose from for selecting which datas to export.

the problem is, when I export let’s say 1 month of data, the script dies.

what I did in order to try to fix the issue was

  • change max_execution_time = 1800 ( this is 30 minutes right? )

  • use set_time_limit()

but no success. the script still dies when data is like too many…

but when I only choose like 2 weeks, 1 week, or a few days amount of data, the exporting works

fine without any hassle,

anyone who encountered this issue?

2

Hi,

After of how many seconds occurs the timeout?

Also check with unlimited time


set_time_limit(0);
3

I can’t actually tell, because it doesn’t finish writing the Excel file at all if the data is too big

the max_execution_time = 60

and then, before the $this->phpexcel(), i set the

set_time_out(1800)

but none of them has helped to let the script finish writing the spreadsheet

4

I had a similar problem with PHPExcel, but I can’t remember what I did to solve it. It might have been a memory issue though, so try increasing your memory_limit ini value.

5

nah…it didn’t helped even i increased the max_execution_time = 1800

6

What did you set the memory limit to?

7

max_execution_time = 1800

set_time_limit(1800)

8

No, memory_limit. I’m saying it may be a memory issue rather than a timeout issue.

Mine is currently set to:




memory_limit = 128M

Try that for testing at least.

9

aren’t there any dangers on that? , it’s a huge site it might crawl if I’ll run the script with that adjusted memory

10

I’m suggesting you set it that high for testing to determine whether memory is the problem or not. If it is, you can tweak the value later.

11

the memory_limit = 512M

isn’t that huge already?