Discussing Schema Design Best Practices and Splitting Collections
TLDR Janaka inquired about resources for schema design and collection splitting. Kishore Nallan advised that splitting should occur for distinct entities and recommended client-side merging and sorting using text match score.
1
Sep 21, 2021 (28 months ago)
Janaka
12:01 PMKishore Nallan
12:04 PMKishore Nallan
12:04 PMJanaka
02:53 PM1
Typesense
Indexed 3015 threads (79% resolved)
Similar Threads
Sorting and Ranking Multi-Search across Collections
Patrick struggles with sorting and ranking multi-search results from different collections. Dima suggests creating a meta-collection, or a collection with raw and searchable fields, and managing sorting manually.
Comparing Text Match Scores Across Separate Collections
Maximilian inquired about comparing text matching scores between collections. Kishore Nallan explained that scores are based on string similarity. They acknowledged an issue with scoring inflation and are working on a solution.
Combining and Sorting Search Results from Two Collections
Toyin asked about combining and sorting search results from two collections. Kishore Nallan confirmed that `text_match` could be used for this purpose.