MySQL Join Optimisation - 2 hours, for what should take seconds!!
Hi, I have been trying to optimise a MySQL script, which for some reason is taking over 2 hours to run! I've been unable to figure out why the script takes so long to run, so any help and tips for identifying the cause of the problem would be appreciated. The script is very simple, essentially: SELECT x.*, y.field1,…
