Open HazardB opened 8 years ago
When the ServerStatus table goes over a certain size, the performance of our main database query lowers significantly.
I've added an index to both the Timestamp and ServerId columns but it hasn't made a huge difference.
Needs investigating and fixing, possibly using a view?
When the ServerStatus table goes over a certain size, the performance of our main database query lowers significantly.
I've added an index to both the Timestamp and ServerId columns but it hasn't made a huge difference.
Needs investigating and fixing, possibly using a view?