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

Add missing indexes to scale

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.5.0-HF14, 5.6.0-HF01
    • Fix Version/s: 5.5.0-HF15, 5.6.0-HF02, 5.7.1
    • Component/s: Core VCS
    • Environment:
      Oracle, PostgreSQL
    • Tags:
    • Upgrade notes:
      Hide

      For customer that have put an index on fulltext jobid you need to remove it because the name has changed:
      DROP INDEX JOBID_ID_IDX;

      Show
      For customer that have put an index on fulltext jobid you need to remove it because the name has changed: DROP INDEX JOBID_ID_IDX;

      Description

      There are missing index on fulltext and nxp_logs that impacts performances
      with > 100kdocuments.

      CREATE INDEX FULLTEXT_JOBID_ID_IDX ON FULLTEXT(JOBID, ID);
CREATE INDEX NXP_LOGS_LOG_DOC_UUID_IDX ON NXP_LOGS(LOG_DOC_UUID);
CREATE INDEX NXP_LOGS_LOG_EVENT_DATE_IDX ON NXP_LOGS(LOG_EVENT_DATE);

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: