Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Repeated DB requests SELECT * FROM oc_termsofservice_sigs WHERE user_id = 'XXXXX' #855

Closed
rdlab-upc opened this issue Sep 4, 2023 · 0 comments · Fixed by #928
Closed

Comments

@rdlab-upc
Copy link

rdlab-upc commented Sep 4, 2023

Hello,

First of all, thank you for the App, is very useful.

We have been tuning our DB, and checking all the NextCloud queries, we found thousands of simultaneous repeated queries for every connected user like:

SELECT * FROM oc_termsofservice_sigs WHERE user_id = 'XXX'

It seems that it checks multiples times the same check for every user instead of one per page/session/connection. It is the normal behaviour to check multiple times the same on a single web page reload?

Could be related with #766 Is the checker recalculating the same checks all the time?

We use the latest 26 branch + php 8.1 + latest MariaDB galera Cluster 10.6 branch + Ubuntu 22.04 LTS.

Thank you!

@rdlab-upc rdlab-upc changed the title Repeated BD requests SELECT * FROM oc_termsofservice_sigs WHERE user_id = 'XXXXX' Repeated DB requests SELECT * FROM oc_termsofservice_sigs WHERE user_id = 'XXXXX' Sep 4, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

1 participant