Hi all, I know this is a loaded question but we are trying to figure out how to best model our data for Typesense. We have the concept of a user(client or professional), posts, and services. In our search experience, we want to display users, services, and posts as different search categories. Services need to have some data from the user model(profile pic, name, username, and location), and posts also need to have some user data(name, username, and profile pic). With that context in mind, is it better to create one collection for users with services and posts stored inside each user document or have separate collections for users, services, and posts and duplicate any user data needed for searching across those collections, which means we have to update every service and post document whenever user data changes?

I would recommend creating separate collections for each of users, posts and services and then duplicating any display fields between the documents in each collection

@Jason Bosco Is there a limit to how many document updates you can batch at a given time?

Is there a limit to how many document updates you can batch at a given time?

Yes, but it depends on the number of CPU cores you have, the size of each document and the total number of documents in the collection. For eg, I’ve been able to update 2.2M documents, with 5-6 fields each, in about 4 minutes on a 4vCPU server

Awesome thank you!