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

[NTLDR]

Working well so far Xenon

With Cache:
Page generated in 0.400 seconds (21.03% PHP - 78.97% MySQL) with 19 queries.

Updating Cache:
Page generated in 0.536 seconds (31.74% PHP - 68.26% MySQL) with 25 queries.

Seems to be loading well all round IMO

[Aaron1]

A little bit off-topic, but its funny to see when your looking at the forumbits from cache_forumhome table before and after a Zlib compression

Before:

<table bgcolor="#0A293E" cellpadding="3" cellspacing="1" border="0" width="100%">
<tr align="center">
<td bgcolor="#1D6AA0"><smallfont> </smallfont></td>
<td bgcolor="#1D6AA0" width="80%" align="left"><smallfont color="#EEEEFF"><b>Forum</b>
</smallfont></td><td bgcolor="#1D6AA0"><smallfont color="#EEEEFF"><b>Posts</b>
</smallfont></td><td bgcolor="#1D6AA0" width="160" nowrap><smallfont color="#EEEEFF">
<b>Last Post</b></smallfont></td>
<td bgcolor="#1D6AA0" width="20%"><smallfont color="#EEEEFF"><b>New Post</b>
</smallfont></td>

Turning into something like this:
After:

sCãGZBçC֣ϤS0~p¼êJ5eµÃy¯£^üËÆ ñѪØGfÃ.oËÉ^,ÿ3ÊÈ
nð±¬ñqÏñ±|ôø¸,^j„<„¬äFÈ3>b!ëg÷|ò ¯¥¦/A¯œ{”Ä›_?–ëæ‘àc¥¶U|¬(d®=Þ
0V40î90VŽ—„I]K¡k)î/–þsh%ÐõÒºŽB×Qhª¿yªïä¦úiHºŽ°??� �?ãì¹@áø%ú:÷„ðâ‘
Í'Â*²–øç'úVµQÞ.Ñw”û½—\êŸ!©ÝÐ}G� �ý=§ûÎÑÓý¹P©S`‡ƒ‹µµqñôâxÍì×� �TŠe¤‡F6
Ÿü²k‰æ*˜XoT¶[<QS®Rh' µ]`bMcâžcbMcâL˜ÔÙ/ýZ’ýº[\ ¸9 :ñ¥_:ñ¥ þ
ƾû£ï@êfvoÖZ

:classic:

[NTLDR]

*hehe* ^^ I agree Its a pain in phpMyAdmin as it causes and error if you click on the edit or delete link. However this is a small price to pay IMO if the compression saves a worthwhile amount of space.

[Xenon]

@Aaron: 1 querie fluctuations are normal, whenever you login into your board after the cookietimeout of your last visit

@boofo: well that one can't work with the hack, because you'd combine dynamical content with cached content.....
to get it back on working correctly you'll lose the cacheing features of my hack

@NTDLR: ahh, good to hear

@Aaron: of course, the first version saves the forumbits in plain html into the db, the new one uses a compression function before savein into db

[Boofo]

Decisions...decisions...ok, I can forgo that hack for now (at least until I can figure a way around it). How about the extra threadviews problem, "buddy"?

[Boofo]

Originally posted by Aaron1
I just checked with a simple phpinfo script:

ZLib Support enabled
'zlib:' fopen wrapper enabled
Compiled Version 1.1.3
Linked Version 1.1.3

I seem to have it installed
Thanks

Can you share the script, please?

[Aaron1]

Oops

Invalid SQL: SELECT COUNT(title) AS starts FROM thread WHERE postusername='d' jam-man' AND open!='10' mysql error: You have an error in your SQL syntax near 'jam-man' AND open!='10'' at line 1

mysql error number: 1064

Date: Saturday 21st of December 2002 09:57:26 PM
Script: http://www.housequake.com/forum/foru...fo&userid=1645
Referer: http://www.housequake.com/

Whats that? Weird?

[Aaron1]

Originally posted by Boofo


Can you share the script, please?

No problem its very simple

Open notepad. Paste this inside:

PHP Code:

<?php
    phpinfo();
?>

Save as: whateveryoulike.php
Upload & voila!

[Boofo]

Ok, that's almost like the one I am using now. Only mine is phpinfo(32). I guess I will have to look closer at it. Thanks!

[Aaron1]

@Boofo: you're welcome, i only wished all coding was that simple

@Xenon: I don't think my problem is related to year hack, because it has something to do with illegal user names; The quote marks seem non allowed? But why do i get a database error for that... But its the first time i get this error.

----

One more thing, is that extra querie i have (yep i never got that marvelous 20 queries back again) due to that Zlib addition?