BeTOriginal post
Web Developer
So i have this database with collections user > topic > notes. Each user can have multiple topics and each topic can contain many notes. if I get user document with no queries, it fetches all of his topics and notes which I think might be slow if he has many notes. I've tried to use select query like so Query.select(['topic.*']). It doesn't return notes but also doesn't return $id of the topic document so I could get notes related to that topic. what would be the best practice here?
Summary
Developers want to query relationships in a database with collections of users, topics, and notes efficiently. They are currently unable to fetch topic documents along with their associated notes. One suggestion is to add a userId attribute to the topic collection as a reference. This way, developers can query the topic document and then fetch notes related to that specific topic using the userId.