php memory limit was 256M
my sql select
Code: Select all
SELECT ucase(u.username) AS username, u.user_id AS uid, p.name AS platoon, p.pid AS pid, c.name AS company, c.id AS cid, m.cmdr AS cmdr, m.in_charge AS rank FROM phpbb3_users u INNER JOIN phpbb3_user_group g ON u.user_id=g.user_id LEFT OUTER JOIN phpbb3_drop_platoon_members m ON u.user_id=m.uid LEFT JOIN phpbb3_drop_platoon p ON p.pid=m.pid LEFT JOIN phpbb3_drop_company c ON p.cid=c.id WHERE g.group_id=145
Code: Select all
function get_pilots_and_units() {
global $template;
$sql="SELECT ucase(u.username) AS username, u.user_id AS uid, p.name AS platoon, p.pid AS pid, c.name AS company, c.id AS cid, m.cmdr AS cmdr, m.in_charge AS rank FROM phpbb3_users u INNER JOIN phpbb3_user_group g ON u.user_id=g.user_id LEFT OUTER JOIN phpbb3_drop_platoon_members m ON u.user_id=m.uid LEFT JOIN phpbb3_drop_platoon p ON p.pid=m.pid LEFT JOIN phpbb3_drop_company c ON p.cid=c.id WHERE g.group_id=145";
while($row=mysql_fetch_array(mysql_query($sql), MYSQL_ASSOC)) {
$template->assign_block_vars('changepilot', array(
'USERNAME' => $row["username"],
'UID' => $row["uid"],
'COMPANY' => $row["company"],
'PLATOON' => $row["platoon"],
'CID' => $row["cid"],
'PID' => $row["pid"],
'CMDR' => $row["cmdr"],
'RANK' => $row["rank"],
));
}
}
So i adjusted php memory step by step to a value of 2560M and now its reaching the time limit....
i dont see the problem, any idea how i can optimize or change the code to a fast and running function?
with 1024 memory limit:
Thank you!( ! ) Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 80 bytes) in /var/www/blutigetempler/forum/phpbb/template/context.php on line 224
Call Stack
# Time Memory Function Location
1 0.0002 243488 {main}( ) ../rooster.php:0
2 0.3190 10752056 get_pilots_and_units( ) ../rooster.php:82
3 193.5808 1073419448 phpbb\template\base->assign_block_vars( ) ../mechfunctions.php:16
4 193.5808 1073419448 phpbb\template\context->assign_block_vars( ) ../base.php:112