Announcement

Collapse
No announcement yet.

Too much querry on search.php (new threads)

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Forum] Too much querry on search.php (new threads)

    what am i doing wrong i dont have much plugins installed atm is below results normal ? 55 queries executed on search.php new messages


    vBulletin 4.0.3 Debug Information
    • Page Generation 2.11420 seconds
    • Memory Usage 5,066KB
    • Queries Executed 55

    More Information Template Usage (26):
    • (1)ad_footer_end
    • (1)ad_footer_start
    • (1)ad_global_above_footer
    • (1)ad_global_below_navbar
    • (1)ad_global_header1
    • (1)ad_global_header2
    • (1)ad_header_end
    • (1)ad_header_logo
    • (1)ad_navbar_below
    • (1)footer
    • (1)gobutton
    • (1)header
    • (1)headinclude
    • (1)headinclude_bottom
    • (1)navbar
    • (2)navbar_link
    • (1)option
    • (1)pagenav
    • (1)pagenav_curpage
    • (3)pagenav_pagelink
    • (1)search_resultlist
    • (20)search_threadbit
    • (1)sevenskins_imageresizer
    • (1)spacer_close
    • (1)spacer_open
    • (22)threadbit_pagelink

    Phrase Groups Available (7):
    • global
    • inlinemod
    • prefix
    • prefix
    • search
    • socialgroups
    • user

    Included Files (50):
    • ./search.php
    • ./global.php
    • ./includes/class_bootstrap.php
    • ./includes/init.php
    • ./includes/class_core.php
    • ./includes/config.php
    • ./includes/functions.php
    • ./includes/class_hook.php
    • ./includes/functions_forumlist.php
    • ./includes/functions_misc.php
    • ./includes/functions_bigthree.php
    • ./includes/functions_forumdisplay.php
    • ./includes/functions_search.php
    • ./includes/functions_databuild.php
    • ./vb/search/core.php
    • ./vb/legacy/currentuser.php
    • ./vb/legacy/user.php
    • ./vb/legacy/dataobject.php
    • ./vb/search/resultsview.php
    • ./vb/search/searchtools.php
    • ./includes/class_xml.php
    • ./includes/functions_socialgroup.php
    • ./includes/class_bootstrap_framework.php
    • ./vb/vb.php
    • ./vb/phrase.php
    • ./includes/class_friendly_url.php
    • ./packages/vbdbsearch/core.php
    • ./packages/vbdbsearch/indexer.php
    • ./vb/search/itemindexer.php
    • ./packages/vbdbsearch/coresearchcontroller.php
    • ./vb/search/searchcontroller.php
    • ./packages/vbdbsearch/postindexcontroller.php
    • ./packages/vbforum/search/indexcontroller/post.php
    • ./vb/search/indexcontroller.php
    • ./vb/legacy/post.php
    • ./vb/legacy/thread.php
    • ./vb/legacy/forum.php
    • ./vb/types.php
    • ./vb/cache.php
    • ./vb/cache/db.php
    • ./vb/cache/observer/db.php
    • ./vb/cache/observer.php
    • ./packages/vbforum/search/type/common.php
    • ./vb/search/type.php
    • ./vb/search/results.php
    • ./vb/search/criteria.php
    • ./includes/functions_notice.php
    • ./packages/vbforum/search/type/thread.php
    • ./packages/vbforum/search/result/thread.php
    • ./vb/search/result.php

    Hooks Called (30):
    • init_startup
    • database_pre_fetch_array
    • database_post_fetch_array
    • fetch_userinfo_query
    • fetch_musername
    • fetch_userinfo
    • global_bootstrap_init_start
    • global_bootstrap_init_complete
    • cache_permissions
    • global_state_check
    • global_bootstrap_complete
    • global_start
    • style_fetch
    • global_setup_complete
    • search_before_process
    • search_start
    • cache_templates
    • template_register_var
    • parse_templates
    • notices_check_start
    • friendlyurl_resolve_class
    • notifications_list
    • process_templates_complete
    • fetch_foruminfo
    • dot_threads_array
    • threadbit_process
    • search_results_threadbit
    • search_complete
    • navbits
    • navbits_complete
    Last edited by gorsani; Sun 16 May '10, 4:31am.

  • #2
    Assuming you are viewing the page as an administrator, you do have database read marking, checking for subscribed threads and dot threads enabled that's about the normal amount of queries:

    Global Queries (per Page)
    • 1 Query to set the SQL mode (which is not needed on many servers but it was decided to add it anyway to reduce the number of support requests for the minority of users who need a special setting)
    • 1 query to load datastore items
    • 1 query to load the session
    • 1 query to load userinfo and language
    • 1 query to load the style
    • 1 Query to load the templates
    • 1 Query to check for dismissed notices

    = 7 queries

    Search Queries (per Page)
    = 8 Queries

    Per Thread Queries
    = 2 queries

    Shutdown Queries (per Page, not counted)
    • 1 Query for updating the session
    • 1 Query for updating lastactivity

    = 2 queries

    So that's 15 + 2*X queries per page, if there are 20 results on the page: 15 + 20*2 = 55 queries.
    Last edited by Andreas; Sun 16 May '10, 6:37am.

    Comment


    • #3
      thats a very long and a nice answer thank you.
      i think i can cut read status query.

      Comment

      widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
      Working...
      X