MySQL Forums
Forum List  »  Full-Text Search

Re: Using UNION instead of OR helps...
Posted by: Ventsislav Alexandriyski
Date: March 24, 2010 11:20PM

If you want to get 0.15 secs then run queries one by one and append results programmatically.

Did you tried left join instead inner? Is there fifference in performance in this case? I am asking because I am wandering why first query takes 0.03, but seccond one takes 0.14 that is much more

-------------------------------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

Options: ReplyQuote


Subject
Views
Written By
Posted
3775
March 24, 2010 06:30PM
Re: Using UNION instead of OR helps...
2618
March 24, 2010 11:20PM
2459
March 25, 2010 04:50AM
3605
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.