Go Back   vb.org Archive > Community Central > Community Lounge
Reload this Page How many Quiers?
FAQ Community Calendar Today's Posts Search

Reply
Page 4 of 4 « First 23 4
 
Thread Tools Display Modes
  #31  
Old 02-14-2002, 11:44 AM
Martz's Avatar
Martz Martz is offline
 
Join Date: Oct 2001
Location: UK
Posts: 156
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
.5 seconds for an extra 101 queries isn't bad though
Reply With Quote
  #32  
Old 02-14-2002, 01:08 PM
Scott MacVicar Scott MacVicar is offline
 
Join Date: Oct 2001
Location: Glasgow, Scotland
Posts: 1,199
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Page generated in 0.39263999462128 seconds with 23 queries,
spending 0.062354683876038 doing MySQL queries and 0.33028531074524 doing PHP things.

Another hack which i noticed took up alot was the last topic title on forumhome that gets the icon as well, for every forum there is a query to the icon table + the thread table to get the title and icon. Mine just stores it in the forum table so it doesn't increase queries.
Reply With Quote
  #33  
Old 02-16-2002, 03:41 AM
Tim Wheatley's Avatar
Tim Wheatley Tim Wheatley is offline
 
Join Date: Nov 2001
Location: England
Posts: 489
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Forum Homepage:

Page generated in 3.5857490301132 seconds with 100 queries,
spending 3.0074957609177 doing MySQL queries and 0.57825326919556 doing PHP things.

Largest Forum's forumdisplay page:
Includes five sub-forums, over 60,000 posts.

Page generated in 0.53195905685425 seconds with 22 queries,
spending 0.29055750370026 doing MySQL queries and 0.24140155315399 doing PHP things.

Thread with over 130 Replies in that largest forum above:

Page generated in 0.95708394050598 seconds with 109 queries,
spending 0.23254978656769 doing MySQL queries and 0.72453415393829 doing PHP things.
Reply With Quote
  #34  
Old 02-16-2002, 05:43 AM
Admin's Avatar
Admin Admin is offline
Coder
  
Join Date: Oct 2023
Location: Server
Posts: 1
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Tim Wheatley, this is not a contest.
Reply With Quote
  #35  
Old 02-16-2002, 11:17 AM
Tim Wheatley's Avatar
Tim Wheatley Tim Wheatley is offline
 
Join Date: Nov 2001
Location: England
Posts: 489
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Oooohhhhhhhh yes it is

Life is ony big contest
Reply With Quote
  #36  
Old 02-18-2002, 05:08 PM
Lesane's Avatar
Lesane Lesane is offline
 
Join Date: Oct 2001
Location: The Netherlands
Posts: 1,149
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
haha

i just installed 2.2.2 with some stats:

Page generated in 3.4783860445023 seconds with 41 queries,
spending 2.6836801767349 doing MySQL queries and 0.79470586776733 doing PHP things.
Reply With Quote
  #37  
Old 02-19-2002, 05:20 PM
tamarian tamarian is offline
 
Join Date: Oct 2001
Location: Canada
Posts: 1,205
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
For those who installed the Sub-Forum hack, it will add many queries, one for each forum and for each sub-forum. You can eliminate the sub-forum queries if you have no private/hidden forum under a public forums. Details are in the sub-forum hack thread.
Reply With Quote
  #38  
Old 03-04-2002, 05:31 PM
DFX DFX is offline
 
Join Date: Feb 2002
Posts: 34
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Page generated in 0.16160094738007 seconds with 24 queries,
spending 0.077735185623169 doing MySQL queries and 0.083865761756897 doing PHP things.

I guess i'm safe
Reply With Quote
Reply
Page 4 of 4 « First 23 4

« Previous Thread | Next Thread »

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT. The time now is 08:09 PM.

Contact Us - Archive - Top

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.03730 seconds
  • Memory Usage 2,243KB
  • Queries Executed 12 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (2)pagenav_pagelink
  • (8)post_thanks_box
  • (8)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (8)post_thanks_postbit_info
  • (8)postbit
  • (8)postbit_onlinestatus
  • (8)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 
Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.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
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • pagenav_page
  • pagenav_complete
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete