Does Typesense support the use case of having hundreds of thousands of collections that have the same schema, but housing different items grouped by owner? Motivation is we have tons of documents and we're finding some filters to not be so great performance-wise when we have it all in just a single collection (search time of 750ms but we'd like to keep it under 50ms). In our queries we always have the owner filter.
k
Kishore Nallan
04/02/2025, 9:07 AM
Tens of thousands of collections is fine. But a middle ground is to have, say 100 collections and assign N different orgs to each collection.
m
Marte Soliza
04/02/2025, 9:22 PM
@Kishore Nallan Are there particular issues we'll encounter if we push it to hundreds of thousands of collections?
Thanks.
h
Harpreet Sangar
04/03/2025, 12:55 AM
@Marte Soliza If you're doing query search along with filtering, you can try sending
enable_lazy_filter: true
in the request. It should improve the response time.