V Parthiban
05/08/2025, 7:36 AMq: "*"
) on page load.
Even though I’m only fetching 20 results, the query takes over 8 seconds to respond. Here's the query:
Search Payload:
{
"collection": "DFXApp",
"q": "*",
"query_by": "system,ocr_data",
"group_limit": "1",
"exclude_fields": "embedding",
"per_page": 20,
"page": 1,
"sort_by": "system.lf.file.properties.ModifiedDate:desc",
"highlight_full_fields": "system,ocr_data",
"facet_by": "system.lf.file.properties.CreatedBy,system.lf.file.properties.CreatedDate,system.lf.file.properties.Extension,system.lf.file.properties.ModifiedDate,system.lf.file.properties.template.template_fields.Client Id,system.lf.file.properties.template.template_fields.Client Name,system.lf.file.properties.template.template_name",
"max_facet_values": 20
}
R*esponse:*
{
"found": 441715,
"out_of": 441716,
"page": 1,
"search_time_ms": 8800
}
How to reduce the response time to under 100ms
(or as close as possible).
Does anyone have tips on:
• Optimizing performance for an empty search (q: "*"
)?
• Best practices for handling large document collections (440k+) with heavy faceting and sorting?
Thanks in advance!