Optimize forumhome, the filburt1 Way

This hack greatly reduces the number of queries on forumhome. On my test board, before:

Page generated in 1.81393003464 seconds with 30 queries,
spending 1.17402160168 doing MySQL queries and 0.639908432961 doing PHP things.

After:

Page generated in 1.37496697903 seconds with 20 queries,
spending 1.00117218494 doing MySQL queries and 0.373794794083 doing PHP things.

The very, very clever hacker can combine elements of this hack and Xenon's to reduce forumhome queries even more; specifically, his optimizations for a moderator cache and Who's Online.

There's also an added benefit: since the number of rows in all tables are cached and not just users, posts, and threads, you can use $counts[tablename] anywhere in forumhome and have the number of rows in tablename show up (for example: Mail Messages: $counts[mailmessage]).

Note that because some PM processing is now given to PHP instead of MySQL, the page load time might increase. It will depend on how many PMs the current user has, among other things. However, the PM handling eliminates two queries.

[sonic3d]

nice. from 22 to 17.

l8er
sonic

[Erwin]

17? Very sweet. I already have 22 on mine with no optimization except my own, but I don't use caching. Just modifying code, and removing things I don't need, like the moderator query (did you know that you can take that away if you don't have a moderator column?).

[Boofo]

But if you have the Miderators listed like they do here on vb.org (Moderated By: ), you still need it right?

[Xenon]

for now, yes, but i'll remove it soon

that's where i like my hack ^^

[Boofo]

But you will still have the "Moderated By:", right?

[limey]

I went from 20 to 13, but the members, posts, and birthdays act wacky so I'm putting it back

[limey]

I went from 20 to 13, but the members, posts, and birthdays act wacky so I'm putting it back

[base]

Yesterday at 11:39 PM Erwin said this in Post #23
17? Very sweet. I already have 22 on mine with no optimization except my own, but I don't use caching. Just modifying code, and removing things I don't need, like the moderator query (did you know that you can take that away if you don't have a moderator column?).

how would i accomplish that? would it simply be a case of removing

PHP Code:

$forummoderators=$DB_site->query('SELECT user.userid,user.username,moderator.forumid
                                  FROM moderator
                                  LEFT JOIN user
                                    ON (moderator.userid=user.userid)
                                  ORDER BY user.username');
while ($moderator=$DB_site->fetch_array($forummoderators)) {
  $imodcache["$moderator[forumid]"][] = $moderator;
  $mod["$moderator[userid]"] = 1;
}
$DB_site->free_result($forummoderators);
unset($moderator); 


from the index.php file, or are there other bits that i've missed? i already have removed the mod columns on forum home etc etc

many thanks in advance

[Xenon]

just remove that part yes

[base]

thank you very muchly, one down, now at 27. i'm thinking about using filburts mods to lower it some more still.