#community-help

Debating Collection Limitations in Typesense

TLDR Bill inquires about creating unique collections for each movie title. Kishore Nallan suggests limiting collections but agrees joined profiles in the next Typesense version will enhance this capability.

Join the chat

Aug 31, 2023 (3 weeks ago)

Photo of md5-be53735a2b0297bb542711c1d2ecea45

Bill

10:16 AM

Hi, is there any limit on how many collections can you create with typesense? For example, in a website that users suggest movies, it would be a good practice to create a collection for each movie title in order to get likes, which users liked it, comments, set filters etc..?

Photo of md5-4e872368b2b2668460205b409e95c2ea

Kishore Nallan

12:32 PM

I've seen people handle 100K+ collections.

12:33

Kishore Nallan

12:33 PM

However a middle ground will be to probably have 1K collections and assign movies into one of the 1000 collections by doing movie_id % 1000

Bill

05:32 PM

I want to filter users that like/comment this specific movie. So in this case wouldn’t be better to have a collection per movie title in order to have users who liked it (profiles) and filter on users eg. Location gender etc..? Btw, the next version of typesense with the joins feature will be great for this case

Sep 01, 2023 (3 weeks ago)

Kishore Nallan

11:49 AM

Yes joins will be a perfect way to do this.

Typesense

Lightning-fast, open source search engine for everyone | Knowledge Base powered by Struct.AI

Indexed 2764 threads (79% resolved)

Join Our Community Manage subscription

Similar Threads

Limiting Returned Array Size and Using Joins in Document Search

James asked how to limit the returned array size in a document search. Jason suggested breaking the document into multiple records. After discussing join options and providing his collections data, James decided to duplicate the parent information in each child. Harpreet confirmed this approach.

yesterday

Updating Bulk Records and Resolving Typsense Issues.

Greg inquired about updating bulk records. Jason proposed using the documents/import endpoint for bulk updating, identified issues with Typesense, and provided solutions. Greg appreciated the assistance. Conversation related to the procedure was shared with Viktor.

10mo

Implementing OR Query in Typesense for Multiple-Word Search

Md.Riad was seeking assistance on implementing an OR query in Typesense for multiple word search. Jason clarified that Typesense already provides this feature by default and suggested to adjust the `drop_tokens_threshold` to obtain more varied results.