Uploaded image for project: 'Jackrabbit Oak'
  1. Jackrabbit Oak
  2. OAK-4029

RDBDocumentStore: optimize the bulk update method

    XMLWordPrintableJSON

Details

    • Improvement
    • Status: Closed
    • Major
    • Resolution: Fixed
    • None
    • 1.4.3, 1.5.0, 1.6.0
    • rdbmk
    • None
    • Patch

    Description

      It seems that the RDBDocumentStoreJDBC.update() method contains a redundant SELECT statement, between the UPDATE and INSERT phase. It's used to find out whether we should INSERT remaining documents or if they already exists in the DB. However, we may skip the middle SELECT and try to INSERT all documents with mod_count = 1.

      The second possible optimisation in this method is skipping the first bulk UPDATE operation if there are no documents to be updated.

      Attachments

        1. OAK-4029.patch
          5 kB
          Tomek Rękawek

        Activity

          People

            reschke Julian Reschke
            tomek.rekawek Tomek Rękawek
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: