Hi!

Try to do the following.

Open admin/exportresults.php

and look for the line

$objWriter = new PHPExcel_Writer_Excel5($workbook);

Before that line insert the following two lines:

$cacheMethod = PHPExcel_CachedObjectStorageFactory::cache_to_discISAM;
PHPExcel_Settings::setCacheStorageMethod($cacheMethod);

It should significatly reduce memory usage - please let me know if this works out.

Hi! i tried your solution, but got the following results:

Webbrowser error message: Firefox can't find the file at http://research.radix-group.com/survey/admin/admin.php?action=exportresults.

and when i redirected the error to the download file:

Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 81 bytes) in /srv/www/vhosts/radix-group.com/subdomains/research/httpdocs/survey/admin/classes/phpexcel/PHPExcel/Cell.php on line 130

sorry to bring no better news.

cheers,

philipp

I can reproduce this problem here on different HW/SW confs.
i tried to raise the php.ini memory in steps up to 4096MB with no result (only apache Server load raised up to 80% :) )

Next 1.91+ Version will use phpExcel 1.7.6 (previously 1.7.4)
Please re-test then.

is this already in the Version 1.91+(10129) or can i skip this and wait for the next?

cheers,

phil

ooops, build number just changed! now it's: Version 1.91+(10120)

Wait for the next ;)

Will do! THX for your great work!
Cheers,

Phil

New version is released.

Hi!

i just installed Version 1.91 Build 10168 and tested with 1279 records. Sorry to disappoint, with less then 512M of PHP Ram, no go, above that, works fine and quicker than in the previous install. not as quick though as in the 1.90+ i attach my htaccess files.
cheers,

philipp

Did the memory consumption change at all?

I saw that I forgot to apply the mentioned patch to the latest version. Only the PHPExcel library was updated. With the caching mechanism applied the memory usage is cut by 45% but still high.
Fixed in rev 10208

New version released.