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

Optimize SQL statement when going through subfolders.

    XMLWordPrintable

    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: