Explaining 'Group By' Function in Search Process
TLDR David asked about the 'group_by' function in search, and any performance costs. Kishore Nallan confirmed it uses runtime memory, but doesn't affect search performance. Further clarification about ranking of groups was given.
1
1
Sep 16, 2023 (2 weeks ago)
David
02:47 PMKishore Nallan
02:49 PMDavid
02:50 PMKishore Nallan
02:50 PMDavid
02:50 PM1
David
02:52 PMexhaustive_search=true
Kishore Nallan
02:52 PMDavid
02:52 PMDavid
04:33 PMpublishedDate:desc
and I want to group by genre
will the groups be sorted so that the genre with the most recent publishedDate is first?Sep 17, 2023 (1 week ago)
Kishore Nallan
03:27 AM1
Typesense
Indexed 2779 threads (79% resolved)
Similar Threads
Understanding `limit_hits` and query performance
Robert asked how `limit_hits` impacts sorting/grouping and search performance. Kishore Nallan explained that `limit_hits` is applied last to prevent deep pagination, and shared the use of `search_cutoff_ms` for limiting large result sets.
Sorting Issues with Typesense's `group_by` Param
Vamshi was puzzled by inconsistent results order in Typesense. Kishore Nallan clarified how `group_by` sorting works, assisting Vamshi in resolving the problem.
Issue with `found` Value in `group_by` Function
Fernando has a question regarding the `found` value in `group_by` function. Jason advises opening a Github issue requesting this feature.
Limiting Search Results by Facet Value
Andrew asks Jason and Kishore Nallan how to limit search results by facet value. Kishore Nallan suggests using group_by function to achieve that, which Andrew accepts.
Typesense Performance with Large Datasets & Custom Sort
krok inquires about Typesense's performance on large datasets and custom sorting. Kishore Nallan explains that Typesense is optimized for this scenario using pagination and text relevance.