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

Enhance query processing in Artifactory with multi-transactional execution

    Details

    • Type: Improvement
    • Status: Open
    • Priority: Normal
    • Resolution: Unresolved
    • Affects Version/s: 6.8.13
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • Sprint:
      R&D Investigation

      Description

      Currently query "SELECT n.* FROM nodes n JOIN node_props p ON n.node_id = p.node_id WHERE repo = ? AND p.prop_key = ?" which is used for searching maven plugin pom files in local repos with property "artifactory.maven.mavenPlugin" = true
      org.artifactory.maven.MavenPluginsMetadataCalculator#calculate. 

      The issue here is not the time it takes for the above query to run, but rather the time Artifactory takes to process all the results, while still keeping the DB transaction open.

      The change should be to make this a multi-transactional process. So the enhancement is to make this multi-transactional.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              Nimerb Nimer Bsoul
            • Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated: