vb.org Archive

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

Admin 02-12-2002 10:09 AM

Huh? Just add the explain variable and scroll to the end of the page.
You can even call it without a value, i.e &explain= so you don't get all the technical stuff.

c-pr0mpt 02-12-2002 10:10 AM

I must be an idiot.

Admin 02-12-2002 10:24 AM

Replace & with ?.

c-pr0mpt 02-12-2002 10:26 AM

Thanks :)

Psychdrone 02-12-2002 11:23 PM

Quote:

Originally posted by FireFly
Yes Psychdrone, that's part of your problem. (see file)
Remove that hack...

I can only guess the access queries are part of vBulletin 9.1.1.

hehe;)

man that hack sucks! Maybe Firefly, you should put a request on so people will inform how many quiers if any, wil be added to the page.....?

Mark Hensler 02-13-2002 03:54 AM

if you look at the queries, it's running inside a loop changing the value of parentid. That could probably be added to the query outside the loop in a JOIN clause.

Admin 02-13-2002 04:48 AM

You can also re-write that hack in a similar fashion to how the actual page is displayed. Write a function called getsubs() that gets a $parentid, then goes through the cache of the forums displaying names of all forums with that $parentid.

Mark Hensler 02-13-2002 05:11 AM

Yes, I suppose you could, FireFly. Couldn't you? ;)

Psychdrone 02-13-2002 10:49 PM

wow that changed my quiers from 59 to 27!

YIKES, thanks Fire;)

eva2000 02-13-2002 10:58 PM

Quote:

Originally posted by Martz
My forumhome:

Page generated in 1.7976969480515 seconds with 131 queries

Too many do you think? *shrug* I have no idea, but you guys are saying 59 is a lot...

holy $h!t :eek:

mine has 30 queries on forumhome but i'm using 2.2.0

Page generated in 1.2088500261307 seconds with 30 queries,
spending 0.75153636932373 doing MySQL queries and 0.45731365680695 doing PHP things.


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