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;
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});
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;
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)