Performance benefit of $and

Andre-John_Mas · October 6, 2020, 10:11am

I ended up writing the test scenario and did find indexed fields coupled with and $and as part of the query did speed things up. Sometimes we were talking a 20ms improvement, going from 22ms to 2ms. For a site with a lot of data and traffic this can add up. Also, since it is such as simple optimisation I’ll take it.

The test scenario I wrote:

gist.github.com

https://gist.github.com/ajmas/249f406ff1d85a8dc8e6a54c6d24175a

mongoose-and.ts

/* eslint-disable no-console */
import mongoose from 'mongoose';

let User;

function generateRandomString (length = 6) {
    return Math.random().toString(20).substr(2, length)
}

async function createEntries () {

This file has been truncated. show original

Feel free to comment on it. I have made it public so it can be improved on.