Is it possible to load only part of very long records in MongoDb?

Question

I have e.g. this record:

{
    Id : "abc...",
    Name : "John Smith",
    List : [
        { Status : "failure abc" },
        { Status : "Success" },
        /*
            ... many many more like that ...
        */
        { Status : "Last entry" }
    ]
}

The List field is very very very long. Can I retrieve only the Id and Name fields, avoiding unnecessarily fetching whole List to save time?

Or do I have to just keep the List in its own collection or as independent record entry?

(Preferably C# code)

You might want to reconsider having large embedded arrays in documents as they can lead to performance issues. For more information see [Why shouldn't I embed large arrays in my documents?](http://askasya.com/post/largeembeddedarrays). — Stennie, Sep 23 '15 at 06:33

Vishwas · Accepted Answer · 2015-09-23T05:52:47.170

2

Yes you can get only Id and name using mongodb's project fields like:

db.collection.find({},{"Id":1,"Name":1})

edited Sep 23 '15 at 05:52

answered Sep 23 '15 at 05:41

Vishwas

6,967
5
42
69

It should be like `collection.Find(query).SetFields(Fields.Exclude("List"))` – Vishwas Sep 23 '15 at 06:01

Is it possible to load only part of very long records in MongoDb?

1 Answers1