Try to run an explain on the query to see how mysql optimizes it.
Also have a look at your system resources while the query runs to see if
you have a problem with memory/swapping.
I am not sure (since i've never used union), but my guess is that mysql
uses temporary tables for this, so maybe t
hi,
i have attached my geometric query which is very slow. how to optimize this
query
regards
shann
___
Hot new product - Spider Networks introduces stunning online ePortfolio
solution for students and teachers
http://www.spider-n
