Thomas Guyot-Sionnest wrote: > > I'm not a SQL guru, but here's some thing I'd try... You may get better > help from SQL/MySQL communities. > > * Make sure obj1.name1 is indexed (or is a PK) > * Make sure every columns in the JOINs are indexed/PKs > * Try removing the ORDER BY (i.e. sort it in the application running the > query instead) > > You can also try importing the tables to a different engine (i.e. InnoDB > vs MyISAM) in a new db or with different names, and benchmark it on them. > -- > 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. Any help gratefully received ------------------------------------------------------------------------- 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