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....

[Alien]

Definatly one of the best things you can do for your site, this deserves a major bumpity-bump after 3 months!

[Xenon]

arrigato

[Danielo]

let's try for it....
i hope my actual db query can be lesser

[julius]

Installed.
Before 20 queries, now 16 queries.

Thanks Xenon.

[StrykerContact]

I get this error when I edit a forum and save it (not editing anything)

Database error in vBulletin Control Panel 2.3.2:

Invalid SQL: UPDATE forum SET moderators=' '
mysql error: Unknown column 'moderators' in 'field list'

mysql error number: 1054

==============================================
Help please, I don't think I made an error I did this twice and nothing changed, mayby it's somthing I had installed already that messed up a line of code.

Edit: I fixed it, I don't know why but the step:

find:

PHP Code:

      $DB_site->query("DELETE FROM forumpermission WHERE forumid=$forumid AND ((usergroupid>=1 AND usergroupid<=4) OR usergroupid>6)");
    }
  }

  updateparentlists(); 


change to:

PHP Code:

      $DB_site->query("DELETE FROM forumpermission WHERE forumid=$forumid AND ((usergroupid>=1 AND usergroupid<=4) OR usergroupid>6)");
    }
  }

  updateparentlists();
  updatemoderators(); 


Causes a Mysql error, all I had to do was remove 'updatemoderators();' from under updateparentlists();

It could just be me but I dunno. Great hack.

[Xenon]

easy answer is you have installed the hack incorrectly.

you have to add a column moderators at forum table.
it's the first step you have to do, described in install file

[StrykerContact]

Wow I'm sorry for missing that, I have never missed a step in a hack before without realising it later. Mayby I just missed it because I started right where I saw open index.php thinking everything above it wasn't part of the hacking. Thanks for pointing that out. You don't need to take my suggestion, but organise your instructions a little more, put some indicators and make them easy to identify like:

########################################
Start Install of Hack
########################################

=========================
RUN QUERY
=========================
ALTER TABLE `forum` ADD `moderators` MEDIUMTEXT NOT NULL

=========================
Open Index.php
=========================
Etc etc. Your a much more experienced hacker then me so I'm not going to tell you to do anything, but some people are as dumb as me and screw up like that. Thanks for the great hack.

[Xenon]

i've already planned to organize my hack instructions more when i start vb3 hack releases

[Blizzb]

You make the best hacks Xenon

[Xenon]

thank you very much

[Blizzb]

You are very welcome.

[lifesourcerec]

Something has to be wrong because my queries go down to 30, then throughout the day go as high as 190 (on forum home).

Another thing I noticed. 100% PHP, 0% MySQL.

Page generated in 0.19523704 seconds (100.00% PHP - 0.00% MySQL) with 136 queries.

Now it's back down to 30.

[Xenon]

that has nothing to do with my hack, maybe another hack doesn't work correctly

[GTA3_Mafia]

Before:
Page generated in 0.24079394 seconds (60.95% PHP - 39.05% MySQL) with 24 queries.
[Debug Mode OFF] [PHP v4.3.3] [GZIP disabled] [Server Load: 1.43 ? 0.86 : 0.75]

After:
Page generated in 0.25855207 seconds (77.87% PHP - 22.13% MySQL) with 20 queries.
[Debug Mode OFF] [PHP v4.3.3] [GZIP disabled] [Server Load: 0.58 ? 0.73 : 0.71]

[pdatoon]

Hello guys,

Sorry for my dumb question but where do i get those info "Page loaded in 1.86 seconds - 28.95% Php - 71.05% MySql with 21 queries."

Do i need to install another hack? And is this one working with 2.3.0?

Regards,