MySQL Forums
Forum List  »  Full-Text Search

Re: Using UNION instead of OR helps...
Posted by: James H
Date: March 26, 2010 07:12AM

I could run two separate queries, then combine the result sets in my Java code without too much effort. I'd face a bit of a problem in Java doing the ORDER BY and LIMIT stuff that I have outside of the UNION queries - I would rather keep this in my SQL code as I've experienced Java being really slow when sorting big result sets.

Anyway, UNION with INNER JOINS seems to be working reasonably well, so I'm going to leave it like that for the time being.

Thanks for all your help.

Options: ReplyQuote


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