-
Type: Improvement
-
Status: Resolved
-
Priority: Minor
-
Resolution: Fixed
-
Affects Version/s: 8.10-HF14
-
Component/s: Core MongoDB
-
Release Notes Summary:Some MongoDB indexes are added to improve the performances of the audit
-
Sprint:nxcore 9.3.10
-
Story Points:2
For 8.10 LTS sites when using Mongo for audit logs we need some indexes on nuxeo.audit. Altas, for example, recommends the following:
db.audit.createIndex({ docUUID: 1, eventId: 1 }, {background: true}) db.audit.createIndex({ eventDate: -1 }, {background: true})
I applied this to one of our sites to see if it improves performance which users have reported.