Uploaded image for project: 'Dev - Nexus Repo'
  1. Dev - Nexus Repo
  2. NEXUS-8039

performance advice in logs when querying npm all resource

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 2.11.2
    • Fix Version/s: 2.11.3
    • Component/s: NPM
    • Labels:
      None
    • Story Points:
      1
    • Sprint:
      Sprint 36, Sprint 37

      Description

      Create an npm group repo with the following members:

      npm-hosted ( hosted npm repo )
      npm-proxy ( https://registry.npmjs.org )
      npm-strongloop ( http://npm.strongloop.com/ )
      npm-nodejitsu ( https://registry.nodejitsu.com )

      make a query to:

      > curl -4 http://localhost:8081/nexus/content/groups/npm/-/all -o /dev/null
        % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                       Dload  Upload   Total   Spent    Left  Speed
      100 66.1M    0 66.1M    0     0  86605      0 --:--:--  0:13:21 --:--:-- 16.9M
      

      Some performance related advice prints in logs. Is this advice we need to follow?

      jvm 1    | 2015-01-27 16:21:42,388-0400 INFO  [qtp458034284-83] anonymous com.orientechnologies.common.profiler.OProfiler - {db=npm} [TIP] Query 'select from packageroot where repositoryId='npm-hosted' and @rid > ? limit 1000' fetched more than 50000 records: to speed up the execution, create an index or change the query to use an existent index
      jvm 1    | 2015-01-27 16:21:44,091-0400 INFO  [qtp458034284-83] anonymous com.bolyuba.nexus.plugin.npm.service.internal.ProxyMetadataServiceImpl - Registry root npm-proxy-nodejitsu initial fetch
      jvm 1    | 2015-01-27 16:31:15,760-0400 INFO  [qtp458034284-83] anonymous com.bolyuba.nexus.plugin.npm.service.internal.ProxyMetadataServiceImpl - Registry root npm-proxy-nodejitsu update successful (127910 packages)
      jvm 1    | 2015-01-27 16:31:16,107-0400 INFO  [qtp458034284-83] anonymous com.orientechnologies.common.profiler.OProfiler - {db=npm} [TIP] Query 'select from packageroot where repositoryId='npm-proxy-nodejitsu' and @rid > ? limit 1000' fetched more than 50000 records: to speed up the execution, create an index or change the query to use an existent index
      jvm 1    | 2015-01-27 16:31:17,964-0400 INFO  [qtp458034284-83] anonymous com.bolyuba.nexus.plugin.npm.service.internal.ProxyMetadataServiceImpl - Registry root npm-proxy-strongloop initial fetch
      jvm 1    | 2015-01-27 16:33:56,268-0400 INFO  [qtp458034284-83] anonymous com.bolyuba.nexus.plugin.npm.service.internal.ProxyMetadataServiceImpl - Registry root npm-proxy-strongloop update successful (102683 packages)
      

        Attachments

          Activity

            People

            Assignee:
            jtom Joe Tom
            Reporter:
            plynch Peter Lynch
            Last Updated By:
            Peter Lynch Peter Lynch
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:
              Date of First Response:

                tigCommentSecurity.panel-title