Notes search is very slow via global search

[klemens-u]

Steps to reproduce

1. Open Nextcoud web interface
2. Click on the notes icon to open the notes app
3. Click on the search icon
4. Search for a note title

Actual behaviour

Search is annoyingly slow - many seconds, and worst: "Notes" results are shown last

Expected behaviour

Valid notes search results should be shown immediately similar to e.g. the Android app

Two possible solutions come to mind:

1. Offer a notes-specific search (additional to global search)
2. Fix the global search. E.g. make the app-specific search context aware. When I'm in the notes app, search for notes first, than search other apps like files etc.

Server

Please complete the following information.

Notes app version: 4.6.0
Nextcloud version: 25.0.2

[juliusknorr]

The backend currently gets all notes contents from the files, which is slow.

Building a separate index like in collectives would be an option: https://gitlab.com/collectivecloud/collectives/-/merge_requests/541

However in that case we should think about moving that to a core API so that we don't duplicate code and maintenance effort on two apps.

[klemens-u]

The new 3-column layout has a search field now, which is very nice, but it needs to be full-text search instead of only searching the title.

I created an separate issue for that: #1069