Page 1 of 1

UNION

Posted: Tue Nov 29, 2005 6:27 am
by sebs
If I make a union on 2 tables works slower then making a single select on those 2 tables united?

Posted: Tue Nov 29, 2005 7:09 am
by patrikG
depends on the query

Posted: Tue Nov 29, 2005 7:14 am
by sebs
The 2 querys I am making are almoust the same.The querys are big.Depends how?If you know?Thanks!

Posted: Tue Nov 29, 2005 7:18 am
by patrikG
time them. If you're not sure how to use MySQL (I presume you're using that) from the commandline, use phpMyAdmin to run the different queries and see how long it took.