Register Members List Search Today's Posts Mark Forums Read

Thread Tools
Old 08 Apr 2004, 18:15
azher azher is offline
Join Date: Oct 2001
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:

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
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.
Islamica Community
Reply With Quote
Old 09 Apr 2004, 09:54
azher azher is offline
Join Date: Oct 2001

Nobody has any insights, eh?
Islamica Community
Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools

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

New To Site? Need Help?

All times are GMT. The time now is 13:55.

Layout Options | Width: Wide Color: