[NXP-31530] Add MongoDB index on ecm:isVersion - Nuxeo Issue Tracker

XML

Word

Printable

Release Notes Summary:
New MongoDB index on ecm:isVersion
Tags:
- nxplatform
Upgrade notes:
Hide

For MongoDB backend, create the index manually:

db.default.createIndex( { "ecm:isVersion": 1 } );

Otherwise, the nuxeo server will attempt to create this index if not present at start-up. In the case of an existing instance with large amounts of documents, this process may time out and/or affect performance.
Show
For MongoDB backend, create the index manually: db. default .createIndex( { "ecm:isVersion" : 1 } ); Otherwise, the nuxeo server will attempt to create this index if not present at start-up. In the case of an existing instance with large amounts of documents, this process may time out and/or affect performance.
Team:
PLATFORM
Sprint:
nxplatform #77
Story Points:
1

In order to perform scalable orphan versions garbage collection (~~NXP-27139~~) which will perform a BAF on queries like:

SELECT * FROM Document WHERE ecm:isVersion = 1

an index on ecm:isVersion is needed to be able to scroll on a large repository without timing out.

is required by

NXP-27139 Scalable orphan version cleanup