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

MsSQL indexes need to be inline with the other databases

    Details

    • Type: Improvement
    • Status: Open
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Database
    • Labels:
      None
    • Regression:
      Yes

      Description

      Currently "node_props" table indexes in MsSQL DB are not equivalent to other database causing degraded performance and longer response time for queries (e.g NPM search).

       

      To observe this behavior and improvement following the indexes change follow the below steps:

      1. Setup Artifactory with MsSQL DB
      2. Deploy tens of thousand NPM Packages (~80,000)
      3. Issue 50 NPM search requests concurrently
        $ curl -Lvv -uadmin:password http://localhost:8081/artifactory/api/npm/npm/-/v1/search\?text\=<value>
      1. Tail Artifactory's requets.log and notice the the request time.
      2. Change the indexes in the database
      3. Issue the same commands from #3
      4. Tail Artifactory's requets.log and notice the the request time reduced by ~50%.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              kfira Kfir Avraham
            • Votes:
              3 Vote for this issue
              Watchers:
              4 Start watching this issue

              Dates

              • Created:
                Updated: