#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.

Powered by Struct AI
5
3w
Solved
Join the chat
Aug 31, 2023 (3 weeks ago)
Bill
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..?
Kishore Nallan
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
Photo of md5-be53735a2b0297bb542711c1d2ecea45
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
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
11:49 AM
Yes joins will be a perfect way to do this.