Uploaded image for project: 'Jackrabbit Oak'
  1. Jackrabbit Oak
  2. OAK-1266 DocumentStore implementation for relational databases
  3. OAK-8002

RDBDocumentStore: add RDB-specific MissingLastRevSeeker

    XMLWordPrintableJSON

Details

    • Technical task
    • Status: Closed
    • Minor
    • Resolution: Fixed
    • None
    • 1.12.0, 1.10.3, 1.8.14
    • rdbmk
    • None

    Description

      MissingLastRevSeeker is slow on DB2. This is because the generic MissingLastRevSeeker gets candidates in batches (of 100), but in order to do batching, requires results to be sorted by ID.

      For DB2 we by default have indices on both ID and MODIFIED, but contrary to our expection a query that involves both indices does not perform well. Adding a compound index on ID and MODIFIED improves performance, but I'm hesitant to add this just to improve a recovery job.

      A more logical approach would be not to require batching/sorting by adopting the approach in MongoMissingLastRevSeeker which doesn't require sorting by ID in the first place.

      Attachments

        1. OAK-8002.diff
          11 kB
          Julian Reschke

        Issue Links

          is related to

          Technical task - A technical task. OAK-8311 RDBDocumentStore: allow to turn off RDB-specific MissingLastRevSeeker

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

          Activity

            People

              reschke Julian Reschke
              reschke Julian Reschke
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: