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

repository formats lacking a groupid concept can suffer from slow db queries due to missing indexes

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.0, 3.1.0, 3.2.0
    • Fix Version/s: 3.2.1
    • Component/s: Database
    • Labels:

      Description

      Repository formats which do not have a group id concept can suffer from slow database query performance. The slowness can manifest itself in a variety of ways:

      • during migration of components/assets from Nexus 2 to Nexus 3 during the upgrade process
      • PUT requests to the affected format hosted repositories in Nexus 3, for example when publishing or deploying new assets

      Affected formats are essentially any format other than Apache Maven.

      The slowness will manifest more prominently in hosted repositories which have very large numbers of assets. For smaller repositories the slowness may not be immediately noticeable.

        Issue Links

          Activity

          Hide
          plynch Peter Lynch added a comment -

          The bug fix addressed by this issue will improve performance during migration, as well as normal PUTs, anything that needs to perform a name/version or name query against the component database.

          Show
          plynch Peter Lynch added a comment - The bug fix addressed by this issue will improve performance during migration, as well as normal PUTs, anything that needs to perform a name/version or name query against the component database.

            People

            • Assignee:
              Unassigned
              Reporter:
              plynch Peter Lynch
              Last Updated By:
              Peter Lynch
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: