The readPackageList call is a fairly complex call and is used frequently. We recently observed some performance issues with it that seemed to relate to the tag_package_owner table.

In many cases, we don't need the ownership data, so it would be more efficient to have an option to avoid the join. The main case for concern is the call to readTaggedRPMS in repo_init, but there could be others.

I suggest adding a with_owners option to readPackageList, which would default to True. If given as False, the query would skip joining the tag_package_owners and users tables.

In the places where we call this function and do not need ownership data, we would set the option to False. In particular, this would include:

• readTaggedBuilds (which only considers the package ids)
• maven_tag_archives (ditto)
• repo_init (only considers package_name and blocked fields)

We might also consider adding the same option to the listPackages api call and passing it through. Some client calls might also benefit from this.