Mongodb: Embedded Users Into Comments

I cant find 'best' solution for very simple problem(or not very) Have classical set of data: posts that attached to users, comments that attached to post and to user. Now i can't d

Solution 1:

You can avoid the N+1-problem of hundreds of requests using $in-queries. Consider this:

Post {
  PosterId:ObjectIdText:stringComments: [ObjectId, ObjectId, ...] //option1
}

Comment {
  PostId:ObjectId//option2(better)Created:dateTime,
  AuthorName:string,
  AuthorId:ObjectId,
  Text:string
}

Now you can find the posts comments with an $in query, and you can also easily find all comments made by a specific author.

Of course, you could also store the comments as an embedded array in post, and perform an $in query on the user information when you fetch the comments. That way, you don't need to de-normalize user names and still don't need hundreds of queries.

If you choose to denormalize the user names, you will have to update all comments ever made by that user when a user changes e.g. his name. On the other hand, if such operations don't occur very often, it shouldn't be a big deal. Or maybe it's even better to store the name the user had when he made the comment, depending your requirements.

A general problem with embedding is that different writers will write to the same object, so you will have to use the atomic modifiers (such as $push). This is sometimes harder to use with mappers (I don't know mongoalchemy though), and generally less flexible.

Solution 2:

What I would do with mongodb would be to embed the user id into the comments (which are part of the structure of the "post" document).

Three simple hints for better performances:

1) Make sure to ensure an index on the user_id

2) Use comment pagination method to avoid querying 200 times the database

3) Caching is your friend

Solution 3:

You could cache your user objects so you don't have to query the database each time.

I like the idea of embedding user data into each post but then you have to think about what happens when a user's profile is updated? have to make sure that no post is missed.

I would recommend starting out just by skimming how mongo recommends you handle schemas.

Generally, for "contains" relationships between entities, embedding should be be chosen. Use linking when not using linking would result in duplication of data.

http://www.mongodb.org/display/DOCS/Schema+Design

Solution 4:

There's a pretty good use case from the MongoDB docs: http://docs.mongodb.org/manual/use-cases/storing-comments/ Conveniently it's also written in Python :-)