vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Community Lounge (https://vborg.vbsupport.ru/forumdisplay.php?f=13)
-   -   Queries... (https://vborg.vbsupport.ru/showthread.php?t=86576)

TheMayhem 03-11-2003 10:37 PM

Queries...
 
Little itty bitty question. Have queries been reduced or something on the vb 3 forums recently. Or in general. VBT is loading unusually too fast at moment for me...

SaintDog 03-11-2003 10:38 PM

Around 10-12 on forumhome I believe, down from what was originally 15-20

Brad 03-11-2003 10:39 PM

Yes, the query count on most, if not all pages has been lowered. Remember however, that sometimes more queries can equal faster, it just depends on how server intensive said queries are. Ive done alot of custimization to my vB 2.3.0 RC forum, i droped a few queries on some pages to make it load faster, i split some large ones on others to speed it up. :)

filburt1 03-11-2003 10:45 PM

vB3 also has vBCron so some queries just aren't performed immediately.

SaintDog 03-11-2003 10:49 PM

Yep, something I am trying to figure out, the Cron says it is sending things out when I do not get anything.....

Brad 03-11-2003 10:49 PM

Quote:

Originally Posted by filburt1
vB3 also has vBCron so some queries just aren't performed immediately.

Just adding to this, A good example of the new 'vBcron' system is seen in the view counts on forumdisplay. They are updated every hour or so. I use a hack that put the new views in a HEAP table then writes them to the threads every 400 pageviews when the server load is not to high. Heres the lastest email i got from my board about the stats:

Quote:

841 Total Views (original number of write queries)
48 Threads (new number of write queries)

94% of Writes Avoided [793 avoided]
18:1 Original Writes vs. Consolidated Writes
I think that speaks for itself, look at how many write where saved :)

TheMayhem 03-12-2003 02:11 AM

Quote:

Originally Posted by Saintdog
Around 10-12 on forumhome I believe, down from what was originally 15-20.

Wow, 10-12 = Cool. My biggest were always showthread.php and newreply so maybe that'll be faster as well. Thanks for explaining things to me. Has anyone else though noticed some speed increases here at VBT?

Dan 03-12-2003 12:21 PM

Not really NOTICED i run a cable line so I don't notice speeds unless I trip my networking cables

Tony G 03-13-2003 03:13 AM

Well on my 56k, there's quite the imrpovement. But the server being top notch makes it a bit harder to realise.


All times are GMT. The time now is 02:43 PM.

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.01035 seconds
  • Memory Usage 1,725KB
  • 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)post_thanks_navbar_search
  • (1)printthread
  • (9)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete