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

[Xenon]

hmm, then the error seems a bit confusing to me...

maybe you can try this:
instead of

PHP Code:

$DB_site->query('DELETE FROM cache_forumhome WHERE userid=' . $bbuserinfo[userid] . iif($numbersmembers['lastpost']>(time()-3600*5), ' OR lastpost<'.(time()-3600*5),'')); 


use smaller values as the timespan:

PHP Code:

$DB_site->query('DELETE FROM cache_forumhome WHERE userid=' . $bbuserinfo[userid] . iif($numbersmembers['lastpost']>(time()-3600*3), ' OR lastpost<'.(time()-3600*3),'')); 


[nuno]

heh Xenon, could it be some kind of caching proggie, Martin's problem?

[Xenon]

i really have no idea what the problem could be...

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 4081664 bytes)

4081664 < 8388608, so it shouldn't be an error....

You mean a caching proggie on the server right?
Well i haven't seen any till now, so i don't know how they work exactly, i wouldn't say this would be the problem, but i can't say for sure

[nuno]

Yup, something like php cache, apc used to do that, the memory errors.
Wild guess i think.

[Xenon]

hmm, maybe you're right, i don't know these scripts.
but it could be, the hack is ok....
also if this is the bug with those cach?ng software, i can't do anything

[Martin CX]

Is there some way of finding out if this is the problem?

[Xenon]

hmm, disable the software

[Martin CX]

Originally posted by Xenon
hmm, disable the software

But WHAT software? What software is it that might cause these problems, and how can I check whether it is installed? (Sorry for all my whining )

[nuno]

Is it a dedicated or shared server?
FreeBSD, Linux, Windoze?
Upload this code into your forums folder

<?
phpinfo();
?>

Save it as phpinfo.php
You should see something like

This program makes use of the Zend scripting language engine:
Zend Engine v1.2.0, Copyright (c) 1998-2002 Zend Technologies
with Your accelerator software credits go here

[Martin CX]

Nope. It just says

This program makes use of the Zend Scripting Language Engine:
Zend Engine v1.1.1, Copyright (c) 1998-2001 Zend Technologies

And it's Linux, BTW.