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

MsSQL indexes need to be inline with the other databases

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: High
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 7.4.0
    • 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:
            barakh Barak Hacham
            Reporter:
            kfira Kfir Avraham
            Votes:
            3 Vote for this issue
            Watchers:
            6 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: