Slow startup time when creating a new client

[gibsonjoshua55]

I just started using the prisma client and I started a small project following the Getting Started guide. After introspecting my database, I copied in the script from the docs and ran it with ts-node; however, it takes about 50 seconds for the line const prisma = new PrismaClient(); to execute. The database introspected has a decent amount of tables, but nothing crazy. Is it normal for this step take this long on every start up?

Details

• script.ts

import { PrismaClient } from '@prisma/client';
console.log("started");
const prisma = new PrismaClient();
console.log("created");
async function main() {
  const users = await prisma.loop_user.findMany({
    where: {
      email: {
        contains: "maadmin"
      }
    }
  });
  console.log(JSON.stringify(users));
}

main()
  .catch(e => {
    throw e;
  })
  .finally(async () => {
    await prisma.disconnect();
  });

• package.json

{
  "name": "prisma-test",
  "version": "1.0.0",
  "main": "index.js",
  "license": "MIT",
  "scripts": {
    "start": "ts-node src/script.ts"
  },
  "devDependencies": {
    "@types/node": "^13.7.7",
    "prisma2": "2.0.0-preview022",
    "ts-node": "^8.6.2",
    "typescript": "^3.8.3"
  },
  "dependencies": {
    "@prisma/client": "2.0.0-preview022"
  }
}

[janpio]

We are aware of some problems with the size, which can also affect the loading time: #524

Can you share the number of tables of your schema?
Or possibly even the schema itself? (If you can not share it publicly, we are happy to sign an NDA: prisma/prisma#757 Having actual real world schemas that show specific problems makes it much easier for us to reproduce and optimize)

[gibsonjoshua55]

We have 94 tables in our schema. I'll chat with my manager about sharing the schema. We'd love to help optimize the project!

[timsuchanek]

@gibsonjoshua55 please try out the latest alpha - we did a major improvement, which should reduce the loading time a lot!

npm install @prisma/client@alpha

[janpio]

Did the recent releases improve the situation @gibsonjoshua55?

[timsuchanek]

Closing this due to inactivity