The Arcive of Official vBulletin Modifications Site.

Optimizing Forumhome · **Released**: 12-19-2002

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

nuno · #**122** 01-04-2003, 06:54 PM

Try to increase memory_limit value in php.ini.

Martin CX · #**123** 01-04-2003, 07:00 PM

Shouldn't 8 megs be enough?

nuno · #**124** 01-04-2003, 07:19 PM

Quote:

Originally posted by Martin CX
It worked fine for some hours, then this:

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 4081664 bytes) in .../index.php on line 408

Fatal error: Allowed memory size of 8388608 bytes exhausted (tried to allocate 45 bytes) in .../admin/db_mysql.php on line 77

Any ideas?

Increase it to 16M

pawel · #**125** 01-06-2003, 07:28 PM

Amazing hack! My page loaded very slow at peak times but now that problem is gone.
Thanks,
Paul

Xenon · #**126** 01-06-2003, 07:44 PM

i enjoy to hear that

N9ne · #**127** 01-19-2003, 11:23 AM

So in this hack, data is being stored in the DB...by how much is my DB size going to increase?

Xenon · #**128** 01-19-2003, 11:29 AM

it's just stored in the DB temporairly, so not real increase of space is there...

Also it depends if you have zlib or not..

N9ne · #**129** 01-19-2003, 11:41 AM

How can I check if I have Zlib? Phpinfo?

edit: Just checked phpinfo and I have this:

--with-zlib'

So what does zlib do?

Xenon · #**130** 01-19-2003, 12:32 PM

with the zlib you should be able to use the compressing function gzdeflate and so on, which has a strong effect on the temp. db size which is needed by my hack

N9ne · #**131** 01-19-2003, 07:29 PM

And what is this about hacks not working with this one? I have a few hacks on forumhome, and one of them is # of users browsing in each forum

Erwin · #**132** 01-20-2003, 10:02 AM

I just saw this hack... Nice work, Stefan as always.

Tony G · #**133** 01-20-2003, 10:38 AM

I heard about this one, good job too!

Xenon · #**134** 01-20-2003, 02:32 PM

thx both of you

@N9ne: well you have to decide what is more important to you, some (not needed in my opinion) hacks or performance.
If you have a lot of users online same time, you should decide for performance, but, if you have just a few users, you can use your hacks.
Also most of the hacks can be combined with this hack if you have good experience in hacking, but some cannot like the # online...

N9ne · #**135** 01-20-2003, 03:58 PM

Well the hacks are very important to me/my members...

At peak times I have about 40-50 users online so I should be alright...I was just looking forward to seeing the query count drop 5

but unfortunately I cannot sacrifice hacks...

Xenon · #**136** 01-20-2003, 07:28 PM

well, your decicion

you can at least install the other querie opts like pm-query and thread ammount thing..

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06646 seconds Memory Usage 2,348KB Queries Executed 30 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (16)post_thanks_box (16)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (16)post_thanks_postbit_info (15)postbit (16)postbit_onlinestatus (16)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!