[openSUSE/open-build-service] 234583: Prevent from performing N+1 queries on user involv...
Branch: refs/heads/master Home: https://github.com/openSUSE/open-build-service Commit: 234583a4dc91fd60b53e262e14cde74b20b5fd55 https://github.com/openSUSE/open-build-service/commit/234583a4dc91fd60b53e26... Author: Eduardo Navarro <enavarro@suse.com> Date: 2024-07-01 (Mon, 01 Jul 2024) Changed paths: M src/api/app/services/user_service/involved.rb Log Message: ----------- Prevent from performing N+1 queries on user involved packages To show the involved items of a user, results are presented sorted by project name and project name/package name. To retrieve the project name of a package, an additional query is performed for every package. This happens for every involved package, independent of being shown in the current paginated page or not, in the sorting method. Include the projects table when querying for involved packages. Therefore, prevent from performing N+1 queries in the case of user involved package. Commit: e80d90d021b9fff7571a192e6b5ae3a0ff1f35b4 https://github.com/openSUSE/open-build-service/commit/e80d90d021b9fff7571a19... Author: Dani Donisa <dani.doni@gmail.com> Date: 2024-07-01 (Mon, 01 Jul 2024) Changed paths: M src/api/app/services/user_service/involved.rb Log Message: ----------- Merge pull request #16432 from eduardoj/fix/involved_packages_n_plus_1_queries Prevent from performing N+1 queries on user involved packages Compare: https://github.com/openSUSE/open-build-service/compare/7ca1a6d72c96...e80d90... To unsubscribe from these emails, change your notification settings at https://github.com/openSUSE/open-build-service/settings/notifications
participants (1)
-
Dani Donisa