[NXP-10912] Allow use of auto-generated integers for VCS doc ids on MS SQL Server - Nuxeo Issue Tracker

XML

Word

Printable

Tags:
- mssql
- performances
Impact type:

Configuration Change
Upgrade notes:

Hide

To activate, in the repository config, add:

<idType>sequence</idType>

Or if you want to use another sequence than the default (hierarchy_seq), use:

<idType>sequence:your_sequence_name</idType>

Show
To activate, in the repository config, add: <idType>sequence</idType> Or if you want to use another sequence than the default (hierarchy_seq), use: <idType>sequence:your_sequence_name</idType>

Following ~~NXP-10894~~, allow using integers from a SEQUENCE to further improve performance for SQL Server.

Note that SEQUENCE is only available since SQL Server 2012, and is not available on Azure.

depends on

NXP-10894 Allow use of auto-generated integers for VCS doc ids on PostgreSQL

is required by

NXP-13800 VCS: auto-generated integer ids on Oracle