Profile page performance issue

[davidfischer]

While working on #5464, I discovered a performance issue on the profile page.

There appears to be a couple duplicated queries in the profile screen. One is to get maintainers for a project and another is to get the latest build. This results in O(n) SQL queries where n is the number of projects displayed. It should be possible to get this data using an annotation.

Parts of this look similar to #5467 and #5465.

There is also one query per project to generate the "view docs" link but that will probably involve refactoring the resolver. You might want to hold off on that as that is not a good first issue. See #3712.

[saadmk11]

@davidfischer should these issues be worked on after merging #5464 or should i install debug toolbar locally and try to resolve them?

[davidfischer]

#5464 will help you work on them but it isn't necessary to fix them.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.