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

Written By
March 24, 2010 06:30PM
Re: Using UNION instead of OR helps...
March 25, 2010 04:50AM
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.