On Wed, Aug 20, 2008 at 8:46 PM, Alan Cooper <[EMAIL PROTECTED]> wrote: > Thanks for the replies, > > Unfortunately, all the tables are already indexed so I'm back to the > underlying problem is that there are so many joins on big tables so > MySQL has to copy to temp tables each time - I'd really like to > eliminate the need for this if possible.
Show the EXPLAIN output as well as SHOW CREATE TABLE for all tables in your query. -- Fridh ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Nagios-users mailing list Nagios-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/nagios-users ::: Please include Nagios version, plugin version (-v) and OS when reporting any issue. ::: Messages without supporting info will risk being sent to /dev/null
