NDO: Setting instance_id as key in more tables?

[Lars Michelsen]

Hi devels,
Im developer of visualization tool Nagvis. I worked a bit on the NDO backend
to optimize the queries to the DB. I recognized that the field instance_id
is not a part of an index/key in some (or some more) tables.

For example we query the following tables in one query:
- nagios_objects and nagios_hoststatus (To get the hoststatus)

- nagios_objects and nagios_servicestatus (To get the servicestatus)

- nagios_objects and nagios_hostgroups (To get the ID of a hostgroup)
- nagios_objects and nagios_hostgroup_members (To get the members of a
hostgroup)

- nagios_objects and nagios_servicegroups (To get the ID of a servicegroup)
- nagios_objects and nagios_servicegroup_members (To get the members of a
servicegroup)

In all cases were filtering the datasets by the instance_id. But not in all
tables the field "instance_id" is indexed or a (part of a) key. I'm not the
mysql geek but I think it would be good to make the field "instance_id" in
table nagios_objects as a key - or a part of a key.
This should make the selects much more faster.

I just had a look at the queries distributed in the ndo package, I
recognized there are always joins to nagios_hosts/nagios_services etc. I
think a JOIN to the table only for checking if this is the correct
"instance_id" is to much overhead.

Some comments/ideas?

Regards,
Lars
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://www.monitoring-lists.org/archive/developers/attachments/20070430/89385704/attachment.html>
-------------- next part --------------
-------------------------------------------------------------------------
This SF.net email is sponsored by DB2 Express
Download DB2 Express C - the FREE version of DB2 express and take
control of your XML. No limits. Just data. Click to get it now.
http://sourceforge.net/powerbar/db2/
-------------- next part --------------
_______________________________________________
Nagios-devel mailing list
Nagios-devel at lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/nagios-devel