Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-10934

Use better clustered indexes on SQL Server

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 5.7.1
    • Component/s: Core VCS
    • Tags:
    • Upgrade notes:
      Hide

      See NXP-10862 for the latest version of the upgrade notes.

      Show
      See NXP-10862 for the latest version of the upgrade notes.

      Description

      SQL Server uses a clustered index to defined how the data is organized physically on disk.

      By default in Nuxeo we don't define a clustered index, so the primary key (for tables with one) is used, however this primary key is a random UUID which means that data keeps getting reorganized on disk on practically every insert or delete.

      Change this to use a synthetic IDENTITY column (which we'll name _oid) which will be used just for the purpose of adding a clustered index on it.

      Also provide a migration script for existing databases.

        Attachments

          Issue Links

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: