Y26-056 - Reduce the loading time of search results #5581
Description
Describe the Housekeeping
Reduce the loading time of search results.
Initial analysis
Recent user queries from production can be found in Google sheets.
Page load times of 9+ seconds can be seen for general queries and samples. This is likely because there are a very large number of samples, and by using double-ended wildcard searches, the indexing cannot be used. There are likely to be other issues at play too.
It's also worth noting that the fields searched are not publicised, nor does the result list indicate why a sample was returned, if the search query was not in the sample name. Sample fields searched are: sample name, supplier name, accession number, and id. In the provided search data, no accession numbers are used as queries.
Blocking issues
None
Additional context
Discovered from Kibana logging
