Out of memory php pdo

Question

Fatal error: Out of memory (allocated 1310720) (tried to allocate 11109600 bytes) in

Reading though here and here .

I got this below from greg's answer

Of course this may reduce server performances as it takes ressources to kill and spaws new processes but at least it keeps the site working. You might be tempted to raise the number of running processes to keep performances high, be sure PHP (or apache) memory limit x max number of processes do not get over your server's physical ram.

and this below from ray's answer

memory_limit: 20000M

Currently I am using xampp as server in my local pc so I am assuming that i can cancel out the first answer because currently my ram is not that high as that of a server I am thinking that if I put this in server I might not get the error. I am considering to the second solution to change the memory_limit. Even if i change my memory_limit to 20000M I still get the problem. But after restating apache in xampp control panel its ok again but if try doing what i was doing before the error return.

What other solutions are best to solve Fatal error: Out of memory.

Raise the memory even higher then. If you don't have enough memory, you'll have to make your code more efficient or get more memory. — , May 30 '15 at 04:30
Is there a max value for memory_limit i didnt change it to higher because i am not sure if there is a maximum number for it @Jamen — Brownman Revival, May 30 '15 at 04:32
I'm guessing that depends on how much memory your machine has. — , May 30 '15 at 04:32
`processor = i5 2.60ghz ram = 8.00gb system type = 64-bit OS,64x-based processor` with this how much will be maximum — Brownman Revival, May 30 '15 at 04:34
Right now `20000M` = `2.5gb` of RAM. You have 8 total... You could go up to like 4gb or higher, just don't do all 8, leave a bit of slack. — , May 30 '15 at 04:38
@JoaozitoPolo any suggestion on how to fix the current problem? — Brownman Revival, May 30 '15 at 04:45

score 0 · Answer 1 · answered May 30 '15 at 12:10

I access the links and read your php code.

I suggest to change the isolate functions to only one, with this structure:

Select the data
    insert into table destination
    generate the line of file

If your file is only to be read on the next function, you don't need to generate anymore.

Out of memory php pdo

1 Answers1