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.
2
Jun 03, 2021 (32 months ago)
Ricardo
06:40 PMdefault_sorting_field
is provided in the schema what's the order returned? insertion order?Jason
06:44 PM_text_match:desc
by default (textual relevance) and if there's a tie, then insertion order, yesRicardo
06:45 PMRicardo
06:45 PM1
Ricardo
06:46 PMJason
06:47 PMJason
06:49 PM1
Typesense
Indexed 3005 threads (79% resolved)
Similar Threads
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.