[IDEA] TickBox to search without loading the message

[marilaki]

Is your feature request related to a problem? Please describe.
When searhing busy feeds - you have to wait 10's of minutes for results to come up.

Describe your use case
A feed that receives 50000 messages a day on average and prune is set to 60 days.

Describe the solution you'd like
A tickbox by the search filter option - search without loading the message - that way we could receive the list of results quickly and load the message only upon clicking on the message. This is particularly important when attempting to see if any result/message had been sent within a timeframe for particular patient.

Describe alternatives you've considered
Rhapsody 🗡️

[pacmano1]

Are you using metadata columns or searching by a string only? 5000 messages a day is very small. There are other solutions available like adding indexes to the db. What is your back end database? Is it running on a separate server or vm?

There is a lot to consider from a performance tuning perspective, please share what you have tuned.