vb.org Archive - Statistics Modifications - Cyb

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.6 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=194)

- - Statistics Modifications - Cyb - Advanced Forum Statistics (https://vborg.vbsupport.ru/showthread.php?t=122986)

This is a really useful mod, however I found that it slows down my forum index a lot. Normal load time without the mod installed is around 0.2 to 0.3s, and with the mod installed its around 1.6 to 2.3s. Currently using the Top 5 Hottest Threads, Most Viewed Threads, and Latest Posts.

After playing around with the queries, I found that removing AND `visible` = '1' and AND `open`!='10' from the WHERE clause speeds up the mod a lot. I'm wondering if there's any bad effects by doing this? Or do you have another suggestion to further optimize the queries.

The ideal way will be to cache them every x minutes or every hour. Pulling the stats dynamically all the time really slows down the forum index.

FYI: We're on a dedicated server with 200-300 online users during peak hours. The database is stored on an external server. Using vBMicroStats, with the mod enabled the load time is around 10% on PHP and 90% on MySQL. Without the mod, it's almost 50-50.

great job, wrks great on my forum, see for urself;

www.dodge-downunder.com

Quote:

Originally Posted by baghdad4ever (Post 1403501)

hi

can you tell me how to add

the most active member today in forum???????

thanks

any idea please???

Can you adjust the width of it?. I love the hack, thanks a lot

To anyone facing time display problems in their stats view: insert %H:%I (Capital H, capital I)

That worked for me!

I've installed it, now I am translating it to Dutch! All phrases can be found with prefix "Cyb", which is great.

Thanks a lot for this plugin/hack.

I am a bit concerned however, having read about increased load times. Does anyone know if it's possible to display page load times in vBulletin forum? SMF is able to display page load times and #queries used at the bottom of each page, but I have not discovered this in vBulletin's options.

Thanks , i was looking for this one !

Thanks for this, my favorite hack and it works with 3.7 perfectly

Quote:

Originally Posted by zenkaizen (Post 1405650)

Same problem on my forum. I am running these stats on a forum with just little over 300k posts and it's basically killing it. It adds up good 3-5 additional seconds to display the main page.

And consider, that this forum is the only website on a very strong dedicated server.
It shouldn't take a more than split of a second to get these stats, so why doesn't it work properly?

Whenever someone hits the main page, this script would use almost 100% of 3gh dual pentium cpu power.

As soon as I disable it, the whole forum is flying like usually.

I don't want to get rid of these stats as me and all my members got used to it, and it's a truly awesome script, but someone should look at this issue and let us know what is happening.

Anyhow, to give you little more details...I am only showing Top Posters, Newest Members and Latest Posts.

I have also removed AND `visible` = '1' and AND `open`!='10' from the WHERE clause and it helped a little bit. But still taking crazy lot of time to generate the front page stats.

Great, works with 3.7.0 BETA 3.

Thanks a lot.

Regards Jason :)

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02744 seconds Memory Usage 1,802KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (4)pagenav_pagelinkrel (1)post_thanks_navbar_search (1)printthread (10)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.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/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.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 printthread_start pagenav_page pagenav_complete bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: