Understanding Default Sorting and Performance Impact in Schema
TLDR Ricardo asked about the default sorting field and the performance impact of sort_by. Jason explained the defaults and potential performance cost when sorting by multiple fields.
Jun 03, 2021 (32 months ago)
default_sorting_fieldis provided in the schema what's the order returned? insertion order?
_text_match:descby default (textual relevance) and if there's a tie, then insertion order, yes
Indexed 3005 threads (79% resolved)
Default Sort Field on Undefined `default_sorting_field`
Scott was confused about the default sort field, to which Jason clarified that the insertion timestamp and text match score are used, depending on the query.
Methods for Fetching, Querying, and Modifying Collections in Typesense
Bill inquired about performing OR queries, querying empty arrays and modifying collections in Typesense. Kishore Nallan explained the current limitations and provided workarounds and recommendations for each case. The conversation also touched upon the usage of cache in Typesense and the workings of the _eval function.
Understanding and Adjusting Query Parameter Weights
John needed help understanding default weights, manipulating weights, and sorting by weight in query parameters. Jason educated on default weights, sorting mechanism, and also suggested using buckets for sorting based on custom fields.