I have…
- [X] Read the following guideline: https://docs.squidex.io/01-getting-started/installation/troubleshooting-and-support. I understand that my support request might get deleted if I do not follow the guideline.
I’m submitting a…
- [ ] Regression (a behavior that stopped working in a new release)
- [ ] Bug report
- [X] Performance issue
- [ ] Documentation issue or request
Current behavior
We are getting a lot of the below alert from MongoDB:
"Query Targeting: Scanned Objects / Returned has gone above 5000
The ratio of scanned documents to returned exceeded 5000.0, which typically suggests that un-indexed queries are being run."
Expected behavior
Having an index that avoids this grand scam
Minimal reproduction of the problem
Environment
App Name: Squidex hosted in uor Azure Cloud with MongoDB
- [ ] Self hosted with docker
- [ ] Self hosted with IIS
- [ ] Self hosted with other version
- [X] Cloud version
Version: Squidex 5.9.0.0
Browser:
- [ ] Chrome (desktop)
- [ ] Chrome (Android)
- [ ] Chrome (iOS)
- [ ] Firefox
- [ ] Safari (desktop)
- [ ] Safari (iOS)
- [ ] IE
- [ ] Edge
The problem is in the DB
Others:
Some time ago, our DBA (SQL Server) adjusted some indexes in MongoDB, but from what we understand, Squidex did not understand these indexes and we even had to delete the index for Squidex to work again.