serverless, prisma 7
ORMHi there. Currently on prisma 6.10.1 in production, aws postgres, aws serverless v4, nodejs 22.x typescript 5.9.x. Nice and fast eg 200ms requests.
I'm trying out prisma 7.4.2, got it working, but I'm getting terrible performance, 10 second requests.
No doubt some combination of my configuration across prisma.schema / tsconfig.json, package.json, prismas.config.ts, serverless.yml etc is not good, possibly it is running prisma generate dynamically for each request or something fundementally bad like that. The query timing on the prisma client log events look OK.
I am looking for a working serverless aws / prisma7 baseline example to follow, but there doesnt seem to be anything that I can find.
schema.prisma:
serverless.yml:
I'm trying out prisma 7.4.2, got it working, but I'm getting terrible performance, 10 second requests.
No doubt some combination of my configuration across prisma.schema / tsconfig.json, package.json, prismas.config.ts, serverless.yml etc is not good, possibly it is running prisma generate dynamically for each request or something fundementally bad like that. The query timing on the prisma client log events look OK.
I am looking for a working serverless aws / prisma7 baseline example to follow, but there doesnt seem to be anything that I can find.
schema.prisma:
generator client {
provider = "prisma-client"
output = "./generated"
compilerBuild = "fast"
}
datasource db {
provider = "postgresql"
}serverless.yml:
org: ..
app: ..
service: ....
plugins:
- serverless-api-gateway-caching
- serverless-prune-versions
- serverless-esbuild
build:
esbuild: false
provider:
name: aws
region: ap-southeast-2
runtime: nodejs22.x
timeout: 90
iamRoleStatements:
- Effect: Allow
Action:
- 'lambda:InvokeFunction'
Resource: '*'
environment:
DIAGNOSTICS_LEVEL: ${env:DIAGNOSTICS_LEVEL}
custom:
esbuild:
bundle: true
minify: false
sourcemap: true
exclude: ['aws-sdk']
target: 'node22'
#define: { 'require.resolve': undefined }
platform: 'node'
concurrency: 10
apiGatewayCaching:
enabled: true
prune:
automatic: true
includeLayers: true
number: 2
# only include the Prisma binary required on AWS Lambda while packaging
package:
individually: true