Performance issues #377
Description
In GitLab by @ognarb on Aug 16, 2022, 12:06
I profiled a bit collectives on our perftesting instance and /index.php/apps/collectives/_api/12/_pages call is quite bad. One of the reasons for this is that the parent are not cached in PageService::getParentPageId. This then created 900 DB requests
One idea how to fix it is to do something similar to nextcloud/end_to_end_encryption#316 (who was also affected by the same bug) or maybe even try to finish nextcloud/server#31793 so that apps don't have to the caching themselves and duplicate the caching (this is also quite a bit more risky)