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:
- Setup Artifactory with MsSQL DB
- Deploy tens of thousand NPM Packages (~80,000)
- Issue 50 NPM search requests concurrently
- Tail Artifactory's requets.log and notice the the request time.
- Change the indexes in the database
- Issue the same commands from #3
- Tail Artifactory's requets.log and notice the the request time reduced by ~50%.