vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 2.x Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=4)
-   -   Deferred Threadviews v1.00 (to reduce server load) (https://vborg.vbsupport.ru/showthread.php?t=40137)

Okiewan 06-24-2002 12:14 PM

Worth the effort (in general) for a baord with 100- 150 online?

Jujubee 06-24-2002 03:36 PM

Quote:

Originally posted by Okiewan
Worth the effort (in general) for a baord with 100- 150 online?
This hack is worth the effort if you need to reduce your load. If you've got 150 users but no load problems, then it's not really necessary. If you're load is above 2, then this hack should help a little. ;)

CJi 06-24-2002 04:11 PM

I get edgy when our load goes above 1.2, so I'm going to put this hack in tomorrow and see how we do. :)

Jujubee 06-24-2002 09:50 PM

Well, after about 18 hours of high load today (shared server), I got this email:
Quote:

5566 Total Views (original number of write queries)
278 Threads (new number of write queries)
5288 Writes Avoided (95% avoided)
5500 MySQL queries distilled into 280 -- now that's what I call efficiency. :bunny:

VirtueTech 06-24-2002 10:01 PM

Quote:

Originally posted by Jujubee
Well, after about 18 hours of high load today (shared server), I got this email:


5500 MySQL queries distilled into 280 -- now that's what I call efficiency. :bunny:

What are your settings all around?

Jujubee 06-24-2002 10:27 PM

Quote:

Originally posted by VirtueTech


What are your settings all around?

My settings? Which ones?

VirtueTech 06-24-2002 10:39 PM

Quote:

Originally posted by Jujubee


My settings? Which ones?

The 3 settings for the script.

Jujubee 06-24-2002 11:53 PM

Quote:

Originally posted by VirtueTech


The 3 settings for the script.

I'm using the default settings. :)

CJi 06-25-2002 06:22 PM

After a little bit of tweaking with the settings, I'd say this works rather well :)

1149 Total Views (original number of write queries)
308 Threads (new number of write queries)

841 Writes Avoided (73% avoided)

Congratulations on a fantastic hack!

ColinP 06-26-2002 02:39 PM

Fantastic hack :)


All times are GMT. The time now is 09:25 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01324 seconds
  • Memory Usage 1,733KB
  • 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
  • (6)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (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