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

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.