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

Add a missing database index on NXP_LOGS.log_doc_uuid

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 5.2 GA
    • Fix Version/s: 5.3.2
    • Component/s: Audit
    • Tags:
    • Upgrade notes:
      Hide

      You need to create an index by hand:

      CREATE INDEX log_doc_uuid_idx ON nxp_logs (log_doc_uuid);

      Show
      You need to create an index by hand: CREATE INDEX log_doc_uuid_idx ON nxp_logs (log_doc_uuid);

      Description

      The history tab performs requests on the audit table (nxp_logs) using a doc id filter,
      having an index on the log_doc_uuid column is not an option when having thouthands of lines.

        Attachments

          Activity

            People

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

              Dates

              • Created:
                Updated:
                Resolved: