max-nextcloud

> That's not using WOPI anymore? It never was. I know it's confusing. Collabora and Officeonline use WOPI, Onlyoffice has it's own protocol. I prepared a pull request to allow...

[Bildschirmaufzeichnung vom 23.05.2024, 07:00:07.webm](https://github.com/nextcloud/server/assets/97337118/9ef4b35e-b314-4038-b72e-26ceaa31cdd3) Another screencast also with removing the share.

@ChristophWurst thanks! That might make it easier to trigger this and test fixes. Disabled recommendations app for now and server is responsive again. I guess when everyone logs in at...

Oh... and also... there were quite a few group folders mentioned in the sloow queries. Might be just because they contain a lot of files or so - but maybe...

Explain with the given query says it uses the `fs_storage_mimetype` index. I tried adding a `fs_storage_mimetype_mtime` index but it would not pick that up.

It looks like the sort is taking most of the time. I wonder if limiting the search to say files that changed within the last two weeks would help. We...

From what i heard the +0 was added to prevent the mtime index from being used. Tests on a productions instance look like the + 0 actually does more harm...

Actually looking at the index used my comparison is wrong... Looks like right now we use the index to exclude non empty folders... Those typically less than 50% of the...

I'm happy to close this. If things are still slow new investigations will be needed anyway.

I just tried to reproduce this copying the [longest good wikipedia article](https://en.wikipedia.org/wiki/Philippines) into a text document. It showed a number of issues: * Editing in firefox still works but file...