Fatal error: Allowed memory size of 8388608 bytes exhausted 1

[superjett]

Not even sure where to start on this one.

Running Apache 2.0.52, PHP 4.3.9, and Fedora core 3.

I have an export to Excel .php that pulls data from SQL 2000 based on a date range you enter. If you have over x amount of data, I get the error

Fatal error:  Allowed memory size of 8388608 bytes exhausted (tried to allocate 2255099 bytes) in /htdocs/excel.php on line 30

Any suggestions on which way to go, PHP or Apache or Linux, or how to allocate more memory for this function?

 

[superjett]

BTW, Linux box is 800mhz, 512mb, etc., more than capable of the small site I'm running.

 

[predamarcel]

Hi,
It's a configuration issue.
take a look in php.ini file
you should have a line like:

memory_limit = 8M

change that value 8M to a bigger value, let's say 12M

Restart apache, and see what you get.


Regards,

PM

___

http://marcel.4x4.ro/

____

 

[superjett]

Thanks for the point/nudge, I'm toying with it now, but may have to set it to -1 for unlimited and use memory_get_usage() to see what my needs are for this script as the db I'm pulling from will eventually get quite large.

 

[superjett]

Just as a conclusion, I came up with about 1.5K/row (83 columns of floating point data) so to get a year's worth of data I came up with around 52Mb. I'll run with that for now.

Thanks again.

 

[predamarcel]

ugh...
52M, a lot of memory, probable you should modify `a little' your script.

PM

___

http://marcel.4x4.ro/

____