Branch: refs/heads/master Home: https://github.com/openSUSE/open-build-service Commit: c92ea1d4a9d4b738cfc3db80aa2ae1001fca66ec https://github.com/openSUSE/open-build-service/commit/c92ea1d4a9d4b738cfc3db... Author: Henne Vogelsang <hvogel@opensuse.org> Date: 2024-05-08 (Wed, 08 May 2024) Changed paths: M src/api/app/models/user.rb Log Message: ----------- Simplify involved_projects/involved_packages query With those two methods we are checking for a maintainer relationship with Project/Packages for the user. The Project/Package default scope hides Project that are access disabled and where the user has *no* maintainer relationship to. So both *can not* be true are the same time. No need to skip hidden projects in the query. Commit: 319fed1bbd47dc281827af114cbaf476f78bc5ae https://github.com/openSUSE/open-build-service/commit/319fed1bbd47dc281827af... Author: Henne Vogelsang <hvogel@opensuse.org> Date: 2024-05-08 (Wed, 08 May 2024) Changed paths: M src/api/app/models/user.rb Log Message: ----------- Simplify incoming_requests/requests queries By running the involved_projects/involved_packages queries up front, this reduces the amount of temporary tables that have to be populated from 16(!) to 4. Commit: d5573dff736a3ed3d9d4ea3b06217591da3a31d6 https://github.com/openSUSE/open-build-service/commit/d5573dff736a3ed3d9d4ea... Author: Saray Cabrera Padrón <scabrerapadron@suse.com> Date: 2024-05-10 (Fri, 10 May 2024) Changed paths: M src/api/app/models/user.rb Log Message: ----------- Merge pull request #16110 from hennevogel/refactoring/user-requests-queries Speed up query Compare: https://github.com/openSUSE/open-build-service/compare/f60852d85abc...d5573d... To unsubscribe from these emails, change your notification settings at https://github.com/openSUSE/open-build-service/settings/notifications