Memory problems with rp

[ncg]

*Fatal error*: Allowed memory size of 16777216 bytes exhausted (tried to allocate 65536 bytes) in */var/hsphere/local/home/xxxxxx/reviews/pp-inc.php* on line *1558

this also happened the otherday when i was trying to backup my database. so i contacted the hosting support and this is what they said:

Hi there,

The problem is;
1. Extremely inefficient PHP code requiring up to 64MB of memory for every single page access
2. A recursive loop in your code which is killing the apache thread in the page.

When temporarily raising the memory limit for the script to 64MB per instance and commenting out the following code in file "weedtracker.com/reviews/pp-inc.php" we can get the page to load.

############################
if ( $CatPerms['children'][$id] != "" ) {
$processkids = explode( ",", $CatPerms['children'][$id] );
while ( list($num, $eachkid) = each($processkids) ) {
if ($CatPerms['ugview'][$eachkid] != 1 ) {
$numproducts += $subcats[$eachkid][3];
$numposts += $subcats[$eachkid][4];
}
$catonline[$id] += $catonline[$eachkid];
}
}
############################

You need to fix and optimize your code. The memory limit per script instance is 32MB.

Kind regards,
Support

[Chuck S]

There should be nothing wrong with that code there. We use that same code in our product and it runs fine on servers which only have 8mb available to PHP scripts.

[ncg]

Originally Posted by Chuck S

There should be nothing wrong with that code there. We use that same code in our product and it runs fine on servers which only have 8mb available to PHP scripts.

i know thats what i said. ive never had a problem so far. my reviews database is getting pretty big, almost 1100 products most with pictures and almost 2000 reviews.

[Chuck S]

yeah if your having performance issues just visit this thread to see if anything helps here. All our products have similar options so this should help. Turn off non essential things.

http://www.photopost.com/forum/showt...38#post1113838