On Aug 20, 2008, at 7:08 AM, Thomas Guyot-Sionnest wrote: > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > On 20/08/08 04:56 AM, Alan Cooper wrote: >> I am having problem scaling up a system we use to gather status data >> from the NDO db: >>
>> Does anyone have any suggestions for improving performance of this >> query? > > 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) I too am not a mysql expert but have some experience with custom ndodb queries... Having proper indexes for the query can make all the difference in the world. The EXPLAIN command, and the many web pages that detail it's use, can be of great assistance in determining which indexes should be created for your query and their benefit. -- Marc ------------------------------------------------------------------------- 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
