XueSheng-GIT

> BTW - The queries in your logs seem to suggest that you use PostgreSQL as the database backend. Could you please confirm/deny? Yes, I'm using postgreSQL.

After applying the latest changes, webdav search fails (with and without File access control enabled). Reverting to the previous patch makes it work again. Here's my search and the error...

Thanks! A quick test was succesful with the updated pull and as fast as the previous approach. Tested with and without File access control. I'm just on my mobile, thus...

Here are the logs using the latest pull on NC 27.0.0 with File access control enabled (same webdav search as before https://github.com/nextcloud/server/pull/37061#issuecomment-1633013375). pgsql query log: [webdav-search_patched-4.log](https://github.com/nextcloud/server/files/12042749/webdav-search_patched-4.log) nextcloud log: [nextcloud_patched-4.log](https://github.com/nextcloud/server/files/12042752/nextcloud_patched-4.log) Search...

Similar to https://github.com/nextcloud/server/issues/35776. For each shared file, another OR statement is required and search really gets slow. Maybe also realated: https://github.com/nextcloud/server/pull/37061

@kesselb How could that be done? The search query is generated by nextcloud and includes (in my case) around thousand storages.

@kesselb maybe you want to have a second look at https://github.com/nextcloud/server/pull/37061 again. Search execution time did improve tremendously.

> 1. you can not filter results by folders (kinda like categories, groups, ...), I found this issue https://github.com/nextcloud/server/issues/42915 which may be related. Generally I assume it makes more sense...

@icewind1991 Any plans for an updated pull for NC28? Search for files is back to more than 60 seconds on my instance (thus, search is practically unusable).

I would argue that this behaviour is still a bug. Uploading a text file (webif or webdav) is no issue. Text file is displayed correctly in Nextcloud (without any changes...