FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » How To » Slow Query
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
Slow Query [message #35065] Mon, 04 December 2006 23:39 Go to previous message
Crimson is currently offline  Crimson   United States
Messages: 51
Registered: June 2005
Location: Phoenix, AZ
Karma:
Member
This query keeps showing up in my slow query log. Can you help me identify which feature is requesting this?

SELECT
                                        m.*,
                                        u.alias,
                                        t.forum_id,
                                        p.name AS poll_name, p.total_votes,
                                        m2.subject AS th_subject,
                                        m3.subject AS reply_subject,
                                        f.name AS frm_name,
                                        c.name AS cat_name
                                FROM
                                        fud_msg m
                                        INNER JOIN fud_thread t ON m.thread_id=t.id
                                        INNER JOIN fud_forum f ON t.forum_id=f.id
                                        INNER JOIN fud_cat c ON c.id=f.cat_id
                                        INNER JOIN fud_msg m2 ON t.root_msg_id=m2.id
                                        LEFT JOIN fud_msg m3 ON m3.id=m.reply_to
                                        LEFT JOIN fud_users u ON m.poster_id=u.id
                                        LEFT JOIN fud_poll p ON m.poll_id=p.id

                                WHERE
                                         t.moved_to=0 AND m.apr=1 ORDER BY m.post_stamp ASC LIMIT 0,100;
[Message index]
 
Read Message
Read Message
Previous Topic: How to convert all FUDforum from ISO-8859-1 to UTF-8?
Next Topic: How to merge two forums?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 28 05:04:17 GMT 2024

Total time taken to generate the page: 0.04135 seconds