MySQL Forums
Forum List  »  InnoDB

Search a joined table
Posted by: Nolan E
Date: July 01, 2009 06:40PM

Hope I'm posting in the right place. Cant figure this one out. I'm doing a query like:

select * from first
left join second on first.id = second.first_id
where
match (second.content) against ('nolanpro' IN BOOLEAN MODE)
or
match (first.content) against ('nolanpro' IN BOOLEAN MODE)

and it is extremely slow!

If I remove the word "left" it runs very fast but I need left because there is not always an entry in 'second' for pointing to 'first' (so its null, and that's cool with me). But It runs for over 90 seconds on a macbook ubuntu, so I don't think its a performance issue.

Each table has a couple thousand rows. Same problem if I replace match/against with like. It also fixes the problem if I replace the word 'or' with 'and' but I need 'or'.

Any ideas? (server version 5.0.67-0ubuntu6)

Options: ReplyQuote


Subject
Views
Written By
Posted
Search a joined table
3818
July 01, 2009 06:40PM
1771
July 02, 2009 11:13AM
1782
July 02, 2009 12:14PM


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.