I am very surprised this is so slow, since the query is limited to only 5 results. Must just be to the overall size of the table.
A cleaning system is need to make sure that the event log doesn't get to large, maybe so many entries per node or only so many days old. The number of days would probably be the best allowing it to be tune-able.
I am very surprised this is so slow, since the query is limited to only 5 results. Must just be to the overall size of the table.
A cleaning system is need to make sure that the event log doesn't get to large, maybe so many entries per node or only so many days old. The number of days would probably be the best allowing it to be tune-able.