Hi guys! I’ve started using N1ql and I have been following your tutorials.
I have noticed many times that a given document (let’s say User) contains an array with the ids of other documents (let’s say orders), from which we can later on perform a join. Is this solution suitable for a situation where a user might have thousands of references?
If not, what is the alternative? What would be the best N1ql query to find all users and their orders (where some users may not have orders)?
Let me know if you need any more information. Thank you!!