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

[solent]

perfect thanks for that. will let you know once my board is in production.

[iwearnosox]

Today at 01:40 PM solent said this in Post #221
perfect thanks for that. will let you know once my board is in production.

solent if you're unfamiliar with basic mysql syntax you might want to see if your host has phpmyadmin, it's got a basic gui front end that might help you.

[solent]

Today at 04:01 PM iwearnosox said this in Post #222
solent if you're unfamiliar with basic mysql syntax you might want to see if your host has phpmyadmin, it's got a basic gui front end that might help you.

well i have no host i build and maintane my own server i am trying my best and upto now i had no problems. anyway this hack has be installed and works just fine i am at the vbmicrostats hack now and hopefully i will set that up to.

[Neopiper]

thx a lot xenon, i got now Page generated in 0.1170980 seconds (17.90% PHP - 82.10% MySQL) with 17 queries.

http://www.animeonline.net/forums/

[mute]

Page generated in 0.47 seconds (16.79% PHP - 83.21%MySQL) with 11 queries.

Yay!

[forumdude]

When users don't have any new pms since their last visit this is what the Private Message box says:

You have new message(s) since your last visit.

where it should be:

You have 0 new message(s) since your last visit.

Anyone else notice this or have the same problem?

Also, it lists fine if there are 1 or more new pms.

[Xenon]

that problem normally can't occur if you have this lines in your code:

PHP Code:

  $unreadpm['messages'] = intval($unreadpm['messages']);
  $newpm['messages'] = intval($newpm['messages']); 


edit: oops, the last line wasn't in the uploaded file, sorry

just add it to your code and it'll work

[forumdude]

Thank you so much.

[DeeperImage]

I have installed it and almost imediately the server loads dropped down to half. Is there a way for me to check how many queries are being requested by typing in some kind of command from phpmyadmin? I dont have the GZIP, Queries hack installed yet. Thanks.

[xs1]

anyone tested in 2.3.0 ?