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

Reply
 
Thread Tools Display Modes
  #1  
Old 09-26-2013, 04:26 PM
keyla31's Avatar
keyla31 keyla31 is offline
 
Join Date: Feb 2009
Posts: 116
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default VB 4.2.1 Slow Heres Cause - What Is It?

My server guy sent me this has the main thing running in vbulletin slowing my site down, but i dont know what it is, please advise:

Copying to tmp table | SELECT
IF(a.votenum >= 1, a.votenum, 0) AS votenum,
IF(a.votenum >= 1 AND a.votenum > 0, a.votetotal / a.votenum, 0) AS voteavg,
a.*, fd.extension AS extension, IF(r.attachrateid >= 1, 1, 0) AS hasvoted,
p.title AS posttitle, p.postid, u.username, p.threadid, t.title AS threadtitle, b.title AS blogtitle, b.blogid
FROM attachment AS a
LEFT JOIN post AS p
ON (a.contenttypeid = 1 AND a.contentid = p.postid)
LEFT JOIN user AS u
ON (a.userid = u.userid)
LEFT JOIN thread AS t
ON (a.contenttypeid = 1 AND p.threadid = t.threadid)
LEFT JOIN blog AS b
ON (a.contenttypeid = 15 AND a.contentid = b.blogid)
LEFT JOIN filedata AS fd
ON (fd.filedataid = a.filedataid)
LEFT JOIN attachrate AS r
ON (a.attachmentid = r.attachid AND r.userid = '0')
WHERE fd.extension IS NOT NULL

AND (t.forumid IN (118,119,120,7,71,72,73,155,156,6,117,31,154) OR a.contenttypeid != 1)

ORDER BY voteavg DESC, a.attachmentid DESC
LIMIT 5050, 50 |

--------------- Added [DATE]1380217373[/DATE] at [TIME]1380217373[/TIME] ---------------

FOUND it, its the attachment gallery mod i put on there, it slows down the site dramatically.
Reply With Quote
  #2  
Old 09-26-2013, 04:59 PM
ForceHSS ForceHSS is offline
 
Join Date: Apr 2008
Posts: 6,357
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default

<a href="https://vborg.vbsupport.ru/showthread.php?t=259302" target="_blank">https://vborg.vbsupport.ru/showthread.php?t=259302</a>
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 12:53 PM.


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