Recurrent DB requests and high load of mariadb cpu consumption since NC27

[Mer0me]

Steps to reproduce

1. Set up NC27 with groupfolders apps and some folders in it
2. Observe the process list of the DB server
3. See a lot of requests concerning oc_group_folders and oc_group_folders_groups tables

Expected behaviour

Database CPU load should be "normal"

Actual behaviour

High load of CPU on the database server and the mariadb process list shows recurrent database requests on oc_groupfolder tables :

CPU is >300% and nextcloud UI is slow.
Server was updated to 27.0.0 two days ago.

Server configuration

Operating system:
Debian 11

Web server:
Apache 2.4.56

Database:
mariadb Ver 15.1 Distrib 10.5.19-MariaDB

PHP version:
8.2

Nextcloud version: (see Nextcloud admin page)
27.0.0

Group folders version:
15.0.0

Updated from an older Nextcloud/ownCloud or fresh install:
updated

Where did you install Nextcloud from:
upgrade from stable channel

Are you using external storage, if yes which one: local/s3/smb/sftp/...
no

Are you using encryption: yes/no
no

Are you using an external user-backend, if yes which one: LDAP/ActiveDirectory/Webdav/Saml/...
LDAP (Active Directory)

Client configuration

Browser:
Firefox 102.11

Operating system:
Debian 11 / Xfce

Logs

Web server error log

Web server error log

no relevant log here.

Nextcloud log (data/nextcloud.log)

Nextcloud log

no relevant log here

Browser log

Browser log

not relevant as it's a server side problem

[ArtificialOwl]

This should already lighten the request, if you are willing to patch your Circles app to test nextcloud/circles#1324

[provokateurin]

@Mer0me can you check if this problem still persists? If so please re-open the issue.

[Mer0me]

@Mer0me can you check if this problem still persists? If so please re-open the issue.

I'm not using group folders app anymore.