{"id":17185,"date":"2015-02-13T12:08:49","date_gmt":"2015-02-13T06:38:49","guid":{"rendered":"https:\/\/2thenew.online\/blog\/?p=17185"},"modified":"2016-08-26T17:37:06","modified_gmt":"2016-08-26T12:07:06","slug":"high-performance-find-query-using-lean-in-mongoose-2","status":"publish","type":"post","link":"https:\/\/2thenew.online\/blog\/high-performance-find-query-using-lean-in-mongoose-2\/","title":{"rendered":"High performance find query using lean() in mongoose"},"content":{"rendered":"

Lets start with a basic find<\/strong> query in mongoose and observe its execution time.<\/p>\n

[js]
\n Event.find({‘schedule.closing’: {‘$gte’: +new Date()}},
\n {},
\n {limit:20, skip:0}
\n ).exec(function (err, events){
\n ……..
\n ……..
\n }
\n);
\n[\/js]<\/p>\n

In my last project on Nodejs<\/a>, I have used the above query to fetch the events from “Event”<\/strong> collection satisfying the given condition. After computing the average execution time, it came out to be 218ms<\/strong>.<\/p>\n

Then, I applied lean()<\/strong> in the same query:<\/p>\n

[js]
\n Event.find({‘schedule.closing’: {‘$gte’: +new Date()}},
\n {},
\n {limit:20, skip:0}
\n ).lean().exec(function (err, events){
\n ……..
\n ……..
\n }
\n);
\n[\/js]<\/p>\n

This time the average execution time came out to be 71ms<\/strong> which is drastically less than the without “lean” version of the same query.<\/p>\n

So, you must be wondering what exactly lean() did here?<\/p>\n

As described by the mongoose docs, documents returned from queries with the lean option true are plain javascript objects, not Mongoose Documents. They have no save method, getters\/setters or other Mongoose magic applied. So in this way the over head attached to the mongoose document is not there in case of lean and we get high performance.<\/p>\n","protected":false},"excerpt":{"rendered":"

Using lean() in mongoose provides high performance queries.<\/p>\n","protected":false},"author":65,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"iawp_total_views":103,"footnotes":""},"categories":[1185],"tags":[4843,55,49,1634,4846,1316,1177],"class_list":["post-17185","post","type-post","status-publish","format-standard","hentry","category-node-js-2","tag-database","tag-javascript","tag-json","tag-lean","tag-mongodb","tag-mongoose","tag-nodejs-2"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t