Forum Moderators: coopster
some of our queries use 6 joins. when i turn on slow query log, these queries regularly popup. i just wondered if anyone could give me some tips on simplifying and / or optimizing them.
just a nod in the right direction would be great.
unfortunately i can't cache them because they are nearly always unique.
cheers
yes... i suppose that was asking for it ;-)
it's just that i read recently that one could simplify complex sql using temporary tables, there was no explanation though. i think that was more to do with simplifying, not optimizing - i was hoping someone might suggest something along those lines. i should have been more precise.
having a skip through the mysql docs does spur me to read up on indexes though - i hardly ever use them and probably never effectively ;-)
thanks!
