vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)
-   -   a question of queries (https://vborg.vbsupport.ru/showthread.php?t=46369)

bahamut0 12-04-2002 12:02 PM

a question of queries
 
hi guys and gals im new to hacking vb and keep seeing this querie thing pop up on hacks about how many it does'nt add.
i have micro stats installed and was wondering if 34 queries for my forum home page is alot?
or what is alot.
my board is brand new i have 7 hacks from here installed and about 4 templete mod's.
only have 3 people there as i just put it up about a week ago.

is this too many or how many should i be looking for or should i not be worried at all right now.

Xenon 12-04-2002 02:17 PM

hmm, it's ok, but not good.

it should stay below 30...

be sure you have alle templates you ahve used because of the hacks also includet into templatesused var in front of the script.

but don't worry, it's not too bad ;)

N9ne 12-04-2002 03:20 PM

Sometimes it also depends on the size of the query...

bahamut0 12-04-2002 04:34 PM

ok i guess i'll just stop with the hacks that add queries for now until i learn a little bit about them and my board get's a little busier.

btw this is my newest board.
Hidden Ones
i am also using the vbindex as well.

guess i have to learn about them a little bit.

but thanks for the replies .

Erwin 12-05-2002 01:34 AM

34 is not too bad. :) I run mine with 27, and my forumhome is hacked beyond recognition. Like Xenon said, keep it below 30 if you can. It's the most used page on your site next to showthreads.php.

bahamut0 12-05-2002 04:42 PM

is tyhere a way to lower the queries without having to uninstall an entire hack?
mabye just stop certain things from being shown.

N9ne 12-05-2002 05:26 PM

If you have the welcome panel hack installed, you can remove the queries for showing the avatar, that reduces two queries.

You can combine all 3 PM queries into one.

The Member Count, Posts Count, Threads Count totals to 3 queries, and the newest member is another one...it's up to you what you want to keep and/or remove.

There are plenty of ways to reduce queries on certain pages, but in effect most of the time it will stop something from appearing...

Xenon 12-05-2002 07:09 PM

optimizing queries isn't that easy, but often possible, so you need a good coder which can work on your file

ps. don't post your files here, it's not allwowed

bahamut0 12-05-2002 07:10 PM

ok thats sounds good my forum right now is'nt busy enough so them welcome panel one's arn't that important right now anyway. thanks for the info.

Erwin 12-06-2002 02:23 AM

You can do the welcome panel with using just templates anyway, no need to have a hack, no extra queries.


All times are GMT. The time now is 03:22 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.00967 seconds
  • Memory Usage 1,727KB
  • 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)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)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