MySQL Forums
Forum List  »  Full-Text Search

Re: Using UNION instead of OR helps...
Posted by: Ventsislav Alexandriyski
Date: March 25, 2010 06:32AM

Ok is there a problem tou run 2 simple queries insted one complex?
I think 0.76 compared to 0.03 is still big

Also try your single line query with left join on union and or variants

-------------------------------Signature-----------------------------------------
http://www.nezavisim.com
I need job so if in your company there is need for optimizing and improving I am the man.
I can work from home via internet. Results are always best

I can complete all tasks from idea to final product, handling hardware desing, programming, installing and configuring all required hadrware and software.
And what can you?

Forum Moderators delete my posts so I cannot write delailed explanations, becaue this will be waste of time when my post is deleted by motherators



Edited 2 time(s). Last edit at 03/25/2010 08:11AM by Ventsislav Alexandriyski.

Options: ReplyQuote


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