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

Optimize SQL statement when going through subfolders.

    Details

      Description

      When going through subfolders, Artifactory uses the following statement:

      SELECT COUNT(1) FROM nodes WHERE repo = 'repo' AND node_path like 'com/xxxxx/<group>/<project> /<subfolder>' AND depth = 6;'.

      This can be slow, replacing 'like' with '=' is much faster. However, with an '=' wildcards cannot be used. Optimize the query so that is wildcards are used, 'like' will be used, but without wildcards, '=' is used in the SQL statement.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                omarf Omar Faiz (Inactive)
              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: