DEV Community

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

Posted on

3 2 1 1 1

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.

SurveyJS custom survey software

Build Your Own Forms without Manual Coding

SurveyJS UI libraries let you build a JSON-based form management system that integrates with any backend, giving you full control over your data with no user limits. Includes support for custom question types, skip logic, an integrated CSS editor, PDF export, real-time analytics, and more.

Learn more

Top comments (0)

Billboard image

The Next Generation Developer Platform

Coherence is the first Platform-as-a-Service you can control. Unlike "black-box" platforms that are opinionated about the infra you can deploy, Coherence is powered by CNC, the open-source IaC framework, which offers limitless customization.

Learn more