vb.org Archive
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   A lot of queries! (https://vborg.vbsupport.ru/showthread.php?t=189537)

TECK 09-12-2008 05:04 PM
Turn the debug mode ON, so you will be able to quickly see detailed information about your query execution. Remove all currently installed products and start adding one by one, while examining the number of queries executed.

Personally, I would recommend you to uninstall all products and leave the standard vBulletin software untouched (code related).

nexialys 09-13-2008 11:19 AM
Quote:
Originally Posted by Lynne (Post 1616646)
It would be interesting to see a list of default queries per page. I realize for some pages it would be a range based on the options you have turned on, but it might help some users. (ie. if the normal amount of queries for a thread page is just 18 and some guy is getting 60, he may have a clue that perhaps his use of queries on the page aren't very efficient.)
best way to do so is by having a default/clean vBulletin, with 100 threads, 10 replies in each, 10 users with avatars etc... open the debug mode, and visit your site...

usually, the number of queries for plain site is about 10 to 15 per page... vBulletin is built to spare on dB queries, but the number is not so important.. if the queries are well built, they are more efficient. a lot of modification use no structural queries, simply by "SELECT ALL FROM TABLE" which is stupid and can be slower than specific selects...


All times are GMT. The time now is 06:25 PM.
Page 2 of 2 1 2
Show 40 post(s) from this thread on one page

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.01018 seconds
  • Memory Usage 1,713KB
  • 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
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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