If I have many posts that belong to a particular user, is it better to do a parent/child relationship or denormalize the data by putting the user in every post document.
In my use-case, the user is regularly being updated, and may have thousands of posts.
I would need to update_by_query all posts that have that user in order to keep the user data accurate.
I would potentially need to update a million or more documents whenever we process new posts (thousands of users with thousands of posts).
With my situation, would it be better to use the join datatype and take a hit on query performance?
Thanks for your help.