DEV Community

Cover image for Make Express Server fast Request & Response Using Indexing in mongoDB
Sandeep
Sandeep

Posted on

Make Express Server fast Request & Response Using Indexing in mongoDB

Hey Developers Today we discuss on topic how we fast our server.
so we learn about indexing in express of mongoose.

normally we can make schemas like

const {Schema,model}=require('mongoose');

const userSchema=new Scheam({
   name:{
      type:String,
      required:true
   },
   email:{
      type:String,
      required:true,
      unique:true
   },
   isDeleted:{
      type:Boolean,
      default:false
   },
});

const UserModel=model('User',userSchema);
module.export=UserModel;
Enter fullscreen mode Exit fullscreen mode

normally we can use to check user on their email. in mongoDB unique

field auto index but other field not index.

const user=await User.findOne({email: "sandeep@gmal.com" , isDeleted:false});
Enter fullscreen mode Exit fullscreen mode

In above query of mongoose it takes more time because isDeleted field not indexed. so we make isDeleted field as index. so refactor model code.

const {Schema,model}=require('mongoose');

const userSchema=new Scheam({
   name:{
      type:String,
      required:true,
      index:true
   },
   email:{
      type:String,
      required:true,
      unique:true
   },
   isDeleted:{
      type:Boolean,
      default:false,
      index:true
   },
});

const UserModel=model('User',userSchema);
module.export=UserModel;
Enter fullscreen mode Exit fullscreen mode

we make name is also in index because in searching query we check from name thats why we make as indexed field.
after make as index field you can see in mongodb document indexed field.

Top comments (0)