MySQL Forums
Forum List  »  Full-Text Search

Re: Using UNION instead of OR helps...
Posted by: James H
Date: March 25, 2010 04:50AM

Just tried LEFT JOINs in the second query, and the time goes up to 0.76secs.

The first query returns 113 rows. The second query returns 686 rows. So, presumably, that's why it's slower(?).

Options: ReplyQuote


Subject
Views
Written By
Posted
3823
March 24, 2010 06:30PM
Re: Using UNION instead of OR helps...
2508
March 25, 2010 04:50AM
3661
March 26, 2010 07:12AM


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.