Uploaded image for project: 'Artifactory Binary Repository'
  1. Artifactory Binary Repository
  2. RTFACT-16201

bundle_files performance improvements

    XMLWordPrintable

    Details

    • Type: Performance
    • Status: Resolved
    • Priority: Normal
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 6.0.0
    • Component/s: None
    • Labels:

      Description

      1) Every time we delete an artifact we check if it's part of a release bundle, and if so the deletion fails.
      This is done by a DB query:
      org.artifactory.storage.db.bundle.dao.ArtifactBundlesDao#getBundlesRelatedToRepoPath

      Indexing repo_path column in bundle_files table will improve performance.

      2) When deleting a repo we currently go through all its files and check one by one whether they are part of a bundle. This is costly. The solution is to add repo_key to bundle_files and check with one query whether the repo_key exists in bundle_files table.

        Attachments

          Activity

            People

            Assignee:
            rotemk Rotem Kfir
            Reporter:
            rotemk Rotem Kfir
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: