Combining Threads, Posts, Members queries on forumhome into one?

[Xenon]

hehe, just found out a way to combine the thread an postcount queries!!!!

in your index.php you find this:

PHP Code:

// get total posts
$countposts=$DB_site->query_first('SELECT COUNT(*) AS posts FROM post');
$totalposts=number_format($countposts['posts']);

$countthreads=$DB_site->query_first('SELECT COUNT(*) AS threads FROM thread');
$totalthreads=number_format($countthreads['threads']); 


replace it with this:

PHP Code:

// get total posts
$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']); 


if the thread/post ammount is incorrect you have tu update your counters in your acp first

[N9ne]

Thanks for that Xenon, but above NTLDR said that it would be less server load with how it is now [an extra query], is this true or will your fix not put more load on the server?

[Xenon]

well i can't say exactly, but i applyed it on my page and, the mysqltime goes down, so i think you can use it

[N9ne]

Ok thanks Xenon

[N9ne]

Do you have anything for showthread and forumdisplay?

[Xenon]

welcome

no, not yet for one of these files, have had some good ideas, but they are a bit into the direction of what logician said, so i canceled the idea because upgrading is so hard with such restructurizations of vb-files

but i think TECK has had some good optimizations hasn't he?

[N9ne]

He has indeed, but it's too hard to get a hold of him