[Resolved] memory shortage?

[perpetualshaun]

We have a client that has the ability to create spreadsheets on-line, writing to a .csv file out othe server and then displaying the link to the file for our client to download.

I coded the interface myself and it's been working great. I guess today is the first time that the client has tried to create a spreadsheet for ALL the contacts in the table (26K+). There are approximately 20 fields for each "row" in the spreadsheet. When I tried to run the routine, I get this message after just a few seconds:

Fatal error: Allowed memory size of 8388608 bytes exhausted at (null):0 (tried to allocate 128 bytes) in /home/virtual/site3/fst/var/www/html/lms/manage/contacts.php on line 138

If I do a search first and try to create a spreadsheet from a smaller result set, it works like a champ! Is there a PHP setting that perhaps I could overide to maybe get the browser to "keep thinking" until it's done? For example, I uploaded a .htaccess file that I've used on other sites w/ this override:

php_value max_execution_time 9999999

But it's not working for this page. Any ideas?

Thanks,

Shaun

[hessian]

There is a line in the php.ini that is set to 8M limit default for a script to consume. I am assuming this is your problem.

The php.ini variable is;
memory_limit

[perpetualshaun]

That did it!

I added this to my .htaccess file:

php_value memory_limit 20M

Ran the script to generate the spreadsheet again and it got all 26K+ rows.

Thanks again