Added index to stats table

Due to a large stats table with about 5 million rows and a somewhat slow performance, we added an index to the table stats to improve this query:
‘UPDATE stat SET end = :toDt WHERE displayId = :displayId AND end IS NULL AND type = :type’

Added index is this:
ALTER TABLE stat ADD INDEX Type (displayID, end, Type);

1 Like

Thank you - we will take a look for 1.7.7: