prisma: Simple MongoDB queries are much slower compared to Mongoose

Bug description

I’m in the middle of refactoring from mongoose to prisma using MongoDB database hosted on MongoDB Atlas. I found out that simple queries are much slower compared to mongoose. We are talking 10-20x slower.

I tried to measure it with console.time and these are the rough results

prisma: 456.724ms
mongoose: 40.727ms

prisma: 473.63ms
mongoose: 28.241ms

How to reproduce

1. Use a hosted MongoDB (I use MongoDB Atlas)
2. Define a simple schema
3. Install both Prisma and Mongoose (to try my code, even Typegoose)
4. Try to perform the same queries with both libraries.

The queries I used are like this

Mongoose query

NewsFeed.find(
    { type: NewsFeedTypes.RELEASE_NOTE },
    {
      title: 1,
      text: 1,
      date: {
        $dateToString: {
          date: '$publicDate',
          format: '%d.%m.%Y',
        },
      },
    }
  )
    .lean()
    .exec();

Mongoose (Typegoose) schema

@modelOptions({
  schemaOptions: {
    collection: 'NewsFeed',
    timestamps: {
      createdAt: 'created',
      updatedAt: 'modified',
    },
  },
})
export class NewsFeedSchema {
  @prop({ ref: () => GridFsFileSchema })
  public image!: Ref<GridFsFileSchema> | null;

  @prop({ type: () => Date })
  public publicDate?: Date;

  @prop({ type: () => String, required: true })
  public text!: string;

  @prop({ type: () => String, required: true })
  public title!: string;

  @prop({ type: () => String, enum: NewsFeedTypes, required: true })
  public type!: NewsFeedType;

  @prop({ type: () => Boolean, required: true, default: false })
  public visibleToBrands!: boolean;

  @prop({ type: () => Boolean, required: true, default: false })
  public visibleToCreative!: boolean;

  public created!: Date;

  public modified!: Date;
}

export const NewsFeed = getModelForClass(NewsFeedSchema);

Expected behavior

It should be roughly the same speed, not 10x-20x slower.

Prisma information

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["filteredRelationCount", "extendedWhereUnique"]
}

datasource db {
  provider = "mongodb"
  url      = env("MONGODB_URI")
}

model NewsFeed {
  id                 String       @id @default(auto()) @map("_id") @db.ObjectId
  image              String?      @db.ObjectId
  publicDate         DateTime?
  text               String
  title              String
  type               NewsFeedType
  visibleToBrands    Boolean      @default(false)
  visibleToDesigners Boolean      @default(false)
  createdAt          DateTime     @default(now()) @map("created")
  updatedAt          DateTime     @updatedAt @map("modified")
}

prisma.newsFeed.findMany({
    where: {
      type: NewsFeedType.RELEASE_NOTE,
      publicDate: {
        lte: new Date(),
      },
    },
  });

Environment & setup

• OS: MacOS
• Database: MongoDB
• Node.js version: 16.17.0

Prisma Version

prisma                  : 4.7.1
@prisma/client          : 4.7.1
Current platform        : darwin-arm64
Query Engine (Node-API) : libquery-engine 272861e07ab64f234d3ffc4094e32bd61775599c (at node_modules/.pnpm/@prisma+engines@4.7.1/node_modules/@prisma/engines/libquery_engine-darwin-arm64.dylib.node)
Migration Engine        : migration-engine-cli 272861e07ab64f234d3ffc4094e32bd61775599c (at node_modules/.pnpm/@prisma+engines@4.7.1/node_modules/@prisma/engines/migration-engine-darwin-arm64)
Introspection Engine    : introspection-core 272861e07ab64f234d3ffc4094e32bd61775599c (at node_modules/.pnpm/@prisma+engines@4.7.1/node_modules/@prisma/engines/introspection-engine-darwin-arm64)
Format Binary           : prisma-fmt 272861e07ab64f234d3ffc4094e32bd61775599c (at node_modules/.pnpm/@prisma+engines@4.7.1/node_modules/@prisma/engines/prisma-fmt-darwin-arm64)
Format Wasm             : @prisma/prisma-fmt-wasm 4.7.1-1.272861e07ab64f234d3ffc4094e32bd61775599c
Default Engines Hash    : 272861e07ab64f234d3ffc4094e32bd61775599c
Studio                  : 0.477.0
Preview Features        : filteredRelationCount, extendedWhereUnique