Optimizing Forumhome

Ok, what this Hack does is it reduces the ammount of queries on forumhome by caching the moderatorlist and by optimizing most of the queries used on index.php


I'd really appreciate getting feedback how it reduces serverload on greater boards

On an unhacked vb index.php (pm enabled accesmask disabled) it reduces the ammount of queries from 19 to 15
my experiments have shown, that the queries are faster than the normal ones, too....

[Boofo]

I don't want it changed if it can be incorporate it into what you already have. It's just that i don't have any threadviews anymore.

I haven't changed anything there (that I can recall). Must be an extra space or something in my file.

[Xenon]

of course, because the threadviewpart was a hack wasn't it?

instead of this code:

PHP Code:

$counters=$DB_site->query_first('SELECT SUM(replycount) AS posts, SUM(threadcount) AS threads FROM forum WHERE parentid=-1');
$totalposts=number_format($counters['posts']);
$totalthreads=number_format($counters['threads']); 


use this one:

PHP Code:

$counters=$DB_site->query_first('SELECT SUM(replycount) AS posts, COUNT(*) AS threads, SUM(views) AS views FROM thread');
$totalposts=number_format($counters['posts']+$counters['threads']);
$totalthreads=number_format($counters['threads']);
$totalviews=number_format($counters['views']); 


so it should work and you have your views again

[Boofo]

Thank you, sir. And I'm still at 17 queries. You are the Man!

I need to ask, though, is it normal to have this hack add 2 queries until the refresh? I mean, it is supposed to do that, right?

By the way, the threadviews was more of a line of code I got from Chen than a hack.

[Xenon]

yes it is normal
as said above the two extra queries are fast one's
but i can't exactly say the performance power, that's why it's here in beta

[Boofo]

Ok, well, I have noticed the page loads a lot quicker and smoother. So, it must be doing something. But, then, my board doesn't have very many users either, so I can't tell on the server load part of it. Although my server load stats in Microstats are showing 0.09, 0.05, 0.09 right now, if that means anything at all.

[NuclioN]

Page loads indeed quicker and it reduced the index queries by ten..that's significant! I hope that you can do this for the showthread. Well done Xenon.

[Dolby]

I went from 18queries to 13queries. Very nice.

[Aaron1]

Yes it works faster, but the downside is i just lost TECKS hack: Latest XX Threads on Forumhome Page. Is there a way to work arround it?

https://vborg.vbsupport.ru/showthrea...threadid=43310

[Xenon]

@Aaron1: i'll look into it when i finished the beta, i'm still working on optimizing

@Boofo: Queries which are inside the makeforumbit function will be reduced always, so if someone has installed the show subforums hack, this hack can save an enourmous ammount of queries.

it always depends on how strong your index.php is hacked

well it's just the field lastupdate which has been included into the new version, it prevents some bugs...
you don't have to upgrade immediatelly, because im sure i'll change the structure a bit soon

Wahh, sortingorder here is completly.......
good it's just beta

[Dean C]

So installing the show sub-forums hack would now only add one query instead of all those queries in the query loop?

- miSt