blank page when downloading results (memory exhausted)

Hi,

I have a similar issue with 24000 results. When I want to see/download the results I get a blank page.

I installed the whole website on a local server and everything works fine, so it might be server resources issue.

Does somebody know if it's possible to add pagination to the results so they will not come as one big block and choke the server?

Thanks,

Y

This might be a solution: http://drupal.org/node/132279 (at least for the results page)

Y

This is a server resources issue:

[Fri Dec 12 10:30:10 2008] [error] [client xx.xxx.xx.xxx] PHP Fatal error:  Allowed memory size of 25165824 bytes exhausted (tried to allocate 223 bytes) in /srv/drupal-6.6/includes/database.mysql-common.inc on line 41, referer: http://www.example.org/survey

You can tweak your settings.php to increase memory and execution time by adding lines like this to the top:

   ini_set('memory_limit', 64M');
   ini_set('max_execution_time', '600');

But at some point it is going to become unreasonable to ratchet up the PHP resources devoted to the webforms module.

And, alpha8007 is correct: there are pagination patches to address problems viewing the results. I haven't found anything to help download the results.

I'm trying to cover all timeout-related bugs in #423350: Improve efficiency of options in select.inc, please take further discussions to that ticket.