MySQL Forums
Forum List  »  Optimizer & Parser

Re: Slow Queries : Using Temporary , Using Filesort
Posted by: Rick James
Date: October 26, 2010 10:37PM

Query 2:

SELECT  o.id, o.title, o.desc, o.uid, o.keyword,
        o.comp
    FROM  uniqueproducts o
    INNER JOIN  mem_pack m ON o.uid = m.uid
    WHERE  o.approv = 1
      AND  m.type = 3
      AND  match(o.title , o.keyword ) against ('+shirt +and +trouser/jeans' in boolean mode)
    GROUP BY  o.uid
    ORDER BY  o.date ASC, o.id ASC
    LIMIT  0, 10;

You need this for FULLTEXT to kick in:
FULLTEXT(title, keyword)

KEY `uid` (`uid`),
Where's the field? It seems to be NULLable? Should it be?

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Slow Queries : Using Temporary , Using Filesort
2398
October 26, 2010 10:37PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.