Re: Using UNION instead of OR helps...
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