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

Allow efficient search by blob key

    XMLWordPrintable

    Details

    • Release Notes Summary:
      The new field ecm:blobKeys is added to denormalize the list of all blob keys.
    • Epic Link:
    • Tags:
    • Upgrade notes:
      Hide

      For migrations of existing databases, an index should be added on ecm:blobKeys:

      db.default.createIndex({"ecm:blobKeys": 1})
      
      Show
      For migrations of existing databases, an index should be added on ecm:blobKeys : db. default .createIndex({ "ecm:blobKeys" : 1})
    • Team:
      FG
    • Sprint:
      nxFG 11.1.13, nxFG 11.3.1
    • Story Points:
      5

      Description

      We need to be able to efficiently search all documents containing a given blob key:

      • to check if a blob is not referenced anymore and can be deleted, after document deletion for instance (this is a limited form of blob GC),
      • to rename a temporary blob key after we've computed a new key based on the content digest.

      To do this, we will add to DBS documents a new internal denormalized list property, ecm:blobKeys, containing the list of all blob keys, and provide a way to query it efficiently using NXQL.

      As a side benefit this will improve the efficiency of the blob GC as it will be sufficient to request this single property.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 2 days
                  2d