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.

        Attachments

          Issue Links

            Activity

              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: