Akash R
07/01/2025, 4:04 AM{
"searches": [
{
"q": "SEARCH_QUERY",
"query_by": "embedding",
"collection": "COLLECTION_NAME",
"filter_by": "date:>=-63158400 && date:<=-61516800",
"exclude_fields": "embedding",
"vector_query": "embedding:([], distance_threshold:0.40)",
"per_page": 20
}
]
}
Response
{
"results": [
{
"facet_counts": [],
"found": 20,
"hits": [SOME DOCS],
"out_of": 4848421,
"page": 1,
"request_params": {
"collection_name": "COLLECTION NAME",
"first_q": "SOME QUERY",
"per_page": 20,
"q": "SOME QUERY"
},
"search_cutoff": false,
"search_time_ms": 21753
}
]
}
Search time is really high
"search_time_ms": 21753Kishore Nallan
07/01/2025, 4:18 AMKishore Nallan
07/01/2025, 4:19 AMAkash R
07/01/2025, 4:35 AMKishore Nallan
07/01/2025, 4:36 AMAkash R
07/01/2025, 4:36 AMKishore Nallan
07/01/2025, 4:37 AMAkash R
07/01/2025, 4:37 AMAkash R
07/01/2025, 4:37 AMKishore Nallan
07/01/2025, 4:38 AMAkash R
07/01/2025, 4:39 AMKishore Nallan
07/01/2025, 4:46 AMAkash R
07/01/2025, 4:52 AM{
"searches": [
{
"q": "*",
"collection": "<COLLECTION_NAME>",
"filter_by": "date:>=-63158400 && date:<=-61516800",
"exclude_fields": "embedding",
"per_page": 20
}
]
}
Only vector query. this gives almost instant results, less than 200 ms
{
"searches": [
{
"q": "<SEARCH_QUERY>",
"query_by": "embedding",
"collection": "<COLLECTION_NAME>",
"exclude_fields": "embedding",
"vector_query": "embedding:([], distance_threshold:0.40)",
"per_page": 20
}
]
}
Same query with combination of both parameters. it takes around 20000 ms.
{
"searches": [
{
"q": "<SEARCH_QUERY>",
"query_by": "embedding",
"collection": "<COLLECTION_NAME>",
"filter_by": "date:>=-63158400 && date:<=-61516800",
"exclude_fields": "embedding",
"vector_query": "embedding:([], distance_threshold:0.40, flat_search_cutoff:30)",
"per_page": 20
}
]
}Kishore Nallan
07/01/2025, 5:03 AMAkash R
07/01/2025, 5:13 AMAkash R
07/01/2025, 10:42 AMRohit Gupta
07/01/2025, 10:48 AMKishore Nallan
07/01/2025, 10:52 AMAkash R
07/01/2025, 10:53 AMKishore Nallan
07/01/2025, 10:59 AM.. operator for the range instead of doing date:>=-63158400 && date:<=-61516800"Akash R
07/01/2025, 11:03 AM.. operator too. still facing the delay. the alteration is in process for range index.Kishore Nallan
07/01/2025, 11:09 AMAkash R
07/01/2025, 11:13 AMKishore Nallan
07/01/2025, 11:13 AMAkash R
07/01/2025, 3:30 PMAkash R
07/01/2025, 3:30 PMrange_index: trueAkash R
07/01/2025, 3:31 PMKishore Nallan
07/01/2025, 4:21 PM