How to fetch data from two collections in one query in mongo db?

Question

Let's say I have two collections A and B. In my C# program I'm trying to get data from them. Currently I get data from collection A first and save the documents into a container. And then get data from collection B. But theoretically speaking, the data may be changed after getting from A and before getting from B. So that I get incorrect results. Is there a safe way?

Andrew Orsich · Accepted Answer · 2011-10-19 09:15:29Z

4

Mongodb does not support transactions. Because of mongodb was designed to be scalable (it means sharding, replication), and distributed transactions can be very expensive and make database slower in general. So you can't block collection A for writes, while you getting/updating it, loading from B.

There is some kind of transactions in mongodb -- it is atomic updates on single document. So you can update part of document without loading of it.

answered Oct 19, 2011 at 9:15

Andrew Orsich

53.8k17 gold badges142 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Polynomial · Accepted Answer · 2011-10-19 08:18:52Z

0

Whilst Mongo doesn't explicitly support locking tables like SQL systems do, you might want to take a look at the fsync function. If I'm reading the docs correctly, you should be able to use it as a hack to temporarily prevent data writes.

http://www.mongodb.org/display/DOCS/fsync+Command

answered Oct 19, 2011 at 8:18

Polynomial

28.4k13 gold badges86 silver badges110 bronze badges

Collectives™ on Stack Overflow

How to fetch data from two collections in one query in mongo db?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related