#community-help

Handling Multiple Collections in Database

TLDR Alan enquired about the implications of having multiple collections. Kishore Nallan advised that schema changes could be challenging and recommended having 4-5 collections assigned based on user id.

Powered by Struct AI
Sep 30, 2022 (15 months ago)
Alan
Photo of md5-6d168f201743aec43607f72d2864612d
Alan
11:55 AM
What's the downside to having thousands or more collections?
Kishore Nallan
Photo of md5-4e872368b2b2668460205b409e95c2ea
Kishore Nallan
12:13 PM
Schema change will require modifying multiple collections. A middle ground is to have 4-5 collections and then assign records based on user id. For eg user_id % 4 to pick the collection to assign to.
Alan
Photo of md5-6d168f201743aec43607f72d2864612d
Alan
01:06 PM
Ty for the quick response.