PHP CLI Question and Memory Usage

[robdog]

I have PHP script that I run through CLI and it is using A LOT of memory. (but it is doing a ton of work)

What techniques should I use to free up memory during the CLI processing?

 

[Shamil]

What does your script do?

 

[robdog]

What does your script do?

A ton of DB queries inside a foreach loop. I have tried using UNSET and the built in PHP garbage collection tags, but nothing really seems to be helping.

 

[Shamil]

I'm generally scared of things like this:

foreach ($array as $key => $data){
     $query = "UPDATE ...";
     $db->query($query);
}

Have you profiled your script?

 

[digitalpoint]

Do you have XenForo's debug config option enabled? It stores a lot of info for each query run...