Simple performance test - Prisma 2 vs mysql Driver

prismaVSmysqlDriver.ts

function getOrdersById(id: number) {
  console.time('NewPrismaClient');
  const prisma = new PrismaClient();
  console.timeEnd('NewPrismaClient');
  console.time('OrmQuery');
  await prisma.tb_orders.findMany({
    where: {
      orderId: id,
    },
  });
  console.timeEnd('OrmQuery');
  console.time('DriverQuery');
  await this.databaseRepository.query(`SELECT *
  FROM tb_orderItems
  WHERE orderId = ${id}`);
  console.timeEnd('DriverQuery');
}

Can you share the results with the latest version of Prisma? prisma/prisma#5819

I do not have the same DB now. But I created a similar environment with docker + postgres. And the new prisma version is faster :).

Evidence:

Example with prisma 3.30.0

Example with prisma 2.17.0

I'm going to try to add more tests with mysql and remote DB.

Nice! Thanks.