New Composite Index Needed
Closed this issue · 1 comments
cmr119 commented
To address some performance issues we saw when the AUDITS table grew to around 300K rows we had to add a new composite index to speed up the query for the max version based on the auditable_id and auditable_type.
add_index "audits", ["auditable_id", "auditable_type", "version"], :name => "auditable_index"kunklejr commented
The version column has been added to the migration for creation of auditable_index. See version 2.3.3.