Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 01-23-2006, 07:50 PM
Wordplay Wordplay is offline
 
Join Date: Nov 2001
Location: Dengoku
Posts: 864
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default too many sqls generating

how can i downgrade the number of sqls generating from one page?
Reply With Quote
  #2  
Old 01-23-2006, 08:12 PM
Andreas's Avatar
Andreas Andreas is offline
 
Join Date: Jan 2004
Location: Germany
Posts: 6,863
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

- Optimize and/or uninstall query-intensive Hacks
- Turn off database read marking
- Turn off users browsing forum/thread
- Turn off moderator column
- Turn off WOL for forumhome
- Turn off similar threads
- more to add probably
Reply With Quote
  #3  
Old 01-23-2006, 08:19 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

By removing all hacks.

Sorry but there is no specific answer to this. Also don't look too much at the number of queries, that is not the most important. Examine the slow query log on your server if that is enabled, this has a much bigger influence on the loadtimes.
Reply With Quote
  #4  
Old 01-23-2006, 09:42 PM
Wordplay Wordplay is offline
 
Join Date: Nov 2001
Location: Dengoku
Posts: 864
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

you 2 are the greatest!

how do i turn off database read marking? and what exactly am i supposed to check in the slow query log?
Reply With Quote
  #5  
Old 02-02-2006, 09:25 AM
Wordplay Wordplay is offline
 
Join Date: Nov 2001
Location: Dengoku
Posts: 864
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

could you please expand on this, and let me know where to find the slow sql log?

took care of everything else.

one more question though, you know how the online button in the postbit and profile shows whether a user is still on, is there anyway to turn that off too? i guess that would down the number of sqls run as well.
Reply With Quote
  #6  
Old 02-02-2006, 04:16 PM
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Location: Nottingham, UK
Posts: 23,748
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Why are you obsessed with reducing the number of queries ?
Reply With Quote
  #7  
Old 02-02-2006, 08:34 PM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Like i mentioned before and Paul M also mentioned now, the number of queries is not very important. The time it takes for each query to execute is.

You can find information about long running SQL-statements in the slow query log. How to activate it you can find the documentation at mysql.com.

Focussing on improving the speed of the slow queries would be the best way to go.
Reply With Quote
  #8  
Old 02-06-2006, 08:37 PM
Wordplay Wordplay is offline
 
Join Date: Nov 2001
Location: Dengoku
Posts: 864
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

this is the problem my provider gives me now that i asked about the length, before that they said there are too many queries running, but right now they say it's because some take up to 2 seconds to load.
Code:
26287 av 17 0 16884 7060 4084 S 3.6 0.3 0:00 0 /usr/bin/php
| 7807 | av_vbboard | localhost | av_vbboard | Query | 0 | Opening tables | SELECT
| 7807 | av_vbboard | localhost | av_vbboard | Query | 1 | Opening tables | SELECT
| 7807 | av_vbboard | localhost | av_vbboard | Query | 2 | closing tables | SELECT
| 7820 | av_vbboard | localhost | | Connect | 0 | Reading from net | |
| 7820 | av_vbboard | localhost | av_vbboard | Query | 0 | closing tables | SELECT title, data
| 7820 | av_vbboard | localhost | av_vbboard | Query | 1 | closing tables | SELECT title, data
| 7820 | av_vbboard | localhost | av_vbboard | Query | 2 | closing tables | SELECT title, data
| 7839 | av_vbboard | localhost | av_vbboard | Query | 0 | Opening tables | SELECT * FROM adv_pages WHERE name = 'home' AND active = 1 |
| 7839 | av_vbboard | localhost | av_vbboard | Query | 0 | Opening tables | SELECT threadid, firstpostid FROM thread AS thread
| 7839 | av_vbboard | localhost | av_vbboard | Query | 0 | Opening tables | SELECT permissions, FIND_IN_SET(forumid, '5,22,-1') AS pos
| 7839 | av_vbboard | localhost | av_vbboard | Query | 1 | Opening tables | SELECT permissions, FIND_IN_SET(forumid, '5,22,-1') AS pos
| 7839 | av_vbboard | localhost | av_vbboard | Query | 0 | Opening tables | SELECT imageid, images.title, filename, thumbname, originalname, extension, images.catid ,images.us |
| 7863 | av_vbboard | localhost | av_vbboard | Query | 0 | Sending data | SELECT title, template
| 7863 | av_vbboard | localhost | av_vbboard | Query | 1 | closing tables | SELECT title, template
does that help anybody because i dont get it.
Reply With Quote
  #9  
Old 02-08-2006, 05:55 AM
Marco van Herwaarden Marco van Herwaarden is offline
 
Join Date: Jul 2004
Posts: 25,415
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

Well from this list you can not see what might be the problem. Ask your host fro a Slow Query log.
Reply With Quote
Reply


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 03:08 AM.


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.04278 seconds
  • Memory Usage 2,237KB
  • Queries Executed 11 (?)
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)bbcode_code
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (9)post_thanks_box
  • (9)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (9)post_thanks_postbit_info
  • (9)postbit
  • (9)postbit_onlinestatus
  • (9)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
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete