Hi,
Hendrik Baecker wrote the following on 2009-11-16 16:42:
> nagios_timedeventqueue
regarding that table it might be inappropriate to define unique keys as
there only is a procedure depending on different states with
insert/update/delete. The other way around it's rather useless to get
doubled rows within timedeventqueue even if they will get deleted soon -
timedevent* happens quite often and the bigger the table the longer an
update will take. It's rather useless for the performance part but I
would suggest rewriting the insert query to insert or update, just like
the normal timedevents query happens for historical purposes.
Kind regards,
Michael
--
DI (FH) Michael Friedrich
[email protected]
Tel: +43 1 4277 14359
Vienna University Computer Center
Universitaetsstrasse 7
A-1010 Vienna, Austria
This post was automatically imported from historical nagios-devel mailing list archives
Original poster: [email protected]