onDelete: Cascade slower with Generated PrismaClient (PlanetScale Adapter)

Hello

Performance Issue with PlanetScale Adapter: Generated PrismaClient vs Direct @prisma/client

We're experiencing significant performance degradation with PlanetScale adapter when using the generated PrismaClient compared to the direct

@prisma/client

@prisma/client

for cascade delete operations.

- Database: PlanetScale (MySQL)
- Prisma Version: 6.16.3
- Adapter: @prisma/adapter-planetscale 6.16.3
- Operation:

db.user.delete()

db.user.delete()

with cascade deletes
- Environment: Local test (Vitest) and CI/CD (GitHub Actions)

- Direct @prisma/client: ~7 seconds
- Generated PrismaClient: ~12 seconds

Prisma•5mo ago•

21 replies