Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
Reload this Page Too many queries?
FAQ Community Calendar Today's Posts Search

Reply
Page 1 of 2 1 2
 
Thread Tools Display Modes
  #1  
Old 07-28-2003, 08:50 AM
Ian Cunningham Ian Cunningham is offline
 
Join Date: Feb 2002
Posts: 221
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Too many queries?
Hi all

I've hacked my boards to pieces, but it seems to be loading REALLY slow... can someone check out my site and tell me if it is loading at a slow speed? I don't think it is my hosts, as they are fast for others.

Are there any threads you recommend that will help with optimising the page? I'm loading the page in one whole table which may also be causeing a problem, as it loads in one block - I don't know how to get round this though!

Ian
Reply With Quote
  #2  
Old 07-28-2003, 09:47 AM
Craigr's Avatar
Craigr Craigr is offline
 
Join Date: May 2002
Location: Ayr, Scotland
Posts: 194
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
The page loads quicky enough for me once it has been found.

Maybe it's something to do with your host, as i maybe waited 20 seconds for the page to be found. Then it loaded quickly.

Craig
Reply With Quote
  #3  
Old 07-28-2003, 09:49 AM
Erwin's Avatar
Erwin Erwin is offline
 
Join Date: Jan 2002
Posts: 7,604
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
It's not that slow using my broadband.

It's not a good idea to load a whole page in 1 table, as nothing shows until everything in that table is downloaded and rendered. Better to have separate tables which load one after the other. But sometimes you can't help it like you say.
Reply With Quote
  #4  
Old 07-28-2003, 11:13 AM
Tony G's Avatar
Tony G Tony G is offline
 
Join Date: Nov 2001
Location: Melbourne, Australia
Posts: 8,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
It could be partially your host, your main page took 30 seconds to come up on my 56k.

As for the forum, it was only like 5 seconds.
Reply With Quote
  #5  
Old 07-29-2003, 06:24 AM
Brad Brad is offline
 
Join Date: Nov 2001
Posts: 4,765
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
As erwin said, one table for the whole page will slow it down alot, try multiple tables or no tables with CSS.
Reply With Quote
  #6  
Old 07-29-2003, 10:09 PM
Ian Cunningham Ian Cunningham is offline
 
Join Date: Feb 2002
Posts: 221
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
cheers guys, will try and modifly the tables now
Reply With Quote
  #7  
Old 02-10-2006, 10:29 PM
testpig's Avatar
testpig testpig is offline
 
Join Date: Apr 2004
Location: Australia
Posts: 44
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Erwin
It's not that slow using my broadband.

It's not a good idea to load a whole page in 1 table, as nothing shows until everything in that table is downloaded and rendered. Better to have separate tables which load one after the other. But sometimes you can't help it like you say.
So how many queries is too many? I'm currently looking at the performance of my board and it gets to about 19 queries in approx .5 / .6 seconds. Is 19 good, bad, or doesnt matter?
Reply With Quote
  #8  
Old 02-10-2006, 11:07 PM
Brad Brad is offline
 
Join Date: Nov 2001
Posts: 4,765
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by testpig
So how many queries is too many? I'm currently looking at the performance of my board and it gets to about 19 queries in approx .5 / .6 seconds. Is 19 good, bad, or doesnt matter?
The number is not as important as what the queries are doing. 10 fast queries would be better than 8 slow ones for example.
Reply With Quote
  #9  
Old 02-11-2006, 07:11 AM
testpig's Avatar
testpig testpig is offline
 
Join Date: Apr 2004
Location: Australia
Posts: 44
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
Quote:
Originally Posted by Brad
The number is not as important as what the queries are doing. 10 fast queries would be better than 8 slow ones for example.
OK.....and out of curiousity the average time of .5 is good, bad, etc? I notice my request here was .3 but with only 13 queries so it seems ok to me. I'm starting to think I have a skin problem
Reply With Quote
  #10  
Old 02-11-2006, 07:53 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default
As long as it stay under 1 second, it will be enough for most people.
Reply With Quote
Reply
Page 1 of 2 1 2

« 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 04:15 AM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04487 seconds
  • Memory Usage 2,254KB
  • Queries Executed 13 (?)
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
  • (3)bbcode_quote
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (10)post_thanks_box
  • (10)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (10)post_thanks_postbit_info
  • (10)postbit
  • (10)postbit_onlinestatus
  • (10)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_postinfo_query
  • fetch_postinfo
  • 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