Efficient Method to Find Records at Interval Timestamps
TLDR Dan asked for an efficient method for counting frequency of record intervals. Jason suggested using multi_search or creating a new field for each record.
2
1
1
Jul 06, 2022 (16 months ago)
Dan
03:16 PM1
Jason
04:09 PMfilter_by: timestamp:>=123 && timestamp:<=345
Dan
04:11 PMDan
04:12 PMDan
04:13 PMJason
04:14 PMtimestamp_interval
and set a common value for all records between x > y, and another common value for all records between y > z, and then facet by that field.Jason
04:15 PMThe actual release date is a unix timestamp, but I created a new field called "Release Date" and extracted just the year into a new string field and I facet by that field for display / filtering purposes, but use the timestamp field for sorting
1
Dan
04:17 PMDan
04:17 PMJason
04:18 PMDan
04:18 PM1
Dan
05:28 PM1
Typesense
Indexed 2779 threads (79% resolved)
Similar Threads
Multiple Filters and JSON Requests in Typesense
Manish asked about multiple filter_by arguments, JSON input, and using multisearch. Jason offered typesense documentation links, examples, and how to use JSON formatted requests with multisearch. Ed shared a similar use case.
Handling Multiple Dates Search with Unix Timestamp in Int64
Akashchellakumar asked how to search multiple dates with Unix timestamp in int64. Kishore Nallan suggested inter-field filtering and storing timestamps as array of int64 or strings. Akashchellakumar thanked and agreed to try this method.
Discussing Typesense Search Request Performance
Al experienced longer-than-reported times for Typesense search requests, sparking a detailed examination of json parsing, response times and data transfer. Jason and Kishore Nallan helped solve the issue.
Fuzzy Search Restrictions and num_typos Extension Request
Ashwin seeks to limit the fields covered by fuzzy search and wants specification of typo tolerance per field. Kishore Nallan suggests num_typos syntax to control the behavior, with Ashwin agreeing and planning to raise a related issue on Github. Jason advises on comparing integer time stamps for InstantSearch usage.
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.