vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB3 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=15)
-   -   Help with slow query (https://vborg.vbsupport.ru/showthread.php?t=63628)

azher 04-08-2004 05:15 PM
Help with slow query
 
Hey, all.

I'm trying to do a "Latest Images" type hack for my forums and while I've seen the other "Recent Attachments" hack that was posted for vB3, it doesn't account for forum permissions or deleted posts, so I thought I'd make my own.

I'm getting a bit hung up, however, on a slow query and I was wondering if anyone else may be able to help shed some light on the matter.

I know that MySQL JOINs can sometimes slow things down as is evident here:

Quote:
SELECT post.userid, post.username, post.postid, deletionlog.primaryid, thread.title, thread.forumid, attachment.postid, attachment.filename, attachment.thumbnail_dateline
FROM post AS post, thread AS thread
LEFT JOIN attachment AS attachment ON ( attachment.postid = post.postid )
LEFT JOIN deletionlog AS deletionlog ON ( deletionlog.primaryid = post.postid )
WHERE post.attach > 0 AND attachment.thumbnail_dateline > 0 AND thread.forumid NOT
IN (
".implode(',', $limitfids)."
) AND ISNULL( primaryid ) AND post.threadid = thread.threadid
ORDER BY post.dateline DESC
LIMIT 6
Is there something I'm missing that can help speed this up? It's currently taking my vbindex homepage from a 0.3-0.6 second generation time to a 2 - 8 second generation time. :(

azher 04-09-2004 08:54 AM
Hmmm....

Nobody has any insights, eh?


All times are GMT. The time now is 12:58 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.01060 seconds
  • Memory Usage 1,711KB
  • 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
  • (1)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)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
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete