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

Drive: optimize audit log query

    XMLWordPrintable

    Details

      Description

      Currently the audit log SQL query to detect the remote changes is quite complex, with a lot of OR / AND clauses to filter the relevant events. Even with the right indexes on the database (especially on the event date, doc UUID, event category), this could lead to long running queries.

      We could make this query faster without any regression in the global performances by removing the event clause and post-filtering the results in Java. Indeed:

      • the query filters events within a date range and related to docs nested in the user's synchronization roots => the number of rows returned should be quite small
      • we are probably interested in most of the events logged for documents, so post-filtering should be efficient (actually we probably want to have all the events and let the client decide of its impact on the synchronization process itself)

        Attachments

          Issue Links

          depends on

          Bug - A problem which impairs or prevents the functions of the product. NXP-14826 Drive: change summary might miss some event if its logDate is not yet commited by the DB in the audit table when the query for changes is run

          • Major - Major loss of function.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. NXP-15859 Fix elasticsearch audit + nuxeo drive

          • Major - Major loss of function.
          • Resolved
          is related to

          Improvement - An improvement or enhancement to an existing feature or task. NXP-23719 Reduce the number of requests sent to the audit

          • Critical - Crashes, loss of data, severe memory leak.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. NXP-19443 Drive: optimize ScrollDescendants operation by avoiding DocumentModel loading

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. NXP-24276 Optimize cache invalidation on drive server

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Open

          Improvement - An improvement or enhancement to an existing feature or task. NXP-24232 Improve getUpperBound query when storing audit in Elasticsearch

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          mentioned in

          Page Loading...

            Activity

              People

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

                Dates

                • Created:
                  Updated:

                  Time Tracking

                  Estimated:
                  Original Estimate - 1 day
                  1d
                  Remaining:
                  Remaining Estimate - 1 day
                  1d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified