perf(db): optimize recurring query paths (#7014) #28145

Job	Run time
Detect Desktop Changes	13s
Detect Version	4s
Build AMD64 (./docker/cron.Dockerfile, ghcr.io/simstudioai/cron, ubuntu-latest, blacksmith-2vcpu-...	18s
Build AMD64 (./docker/pii.Dockerfile, ghcr.io/simstudioai/pii, ECR_PII, ubuntu-latest, blacksmith...	26s
Build AMD64 (./docker/realtime.Dockerfile, ghcr.io/simstudioai/realtime, ECR_REALTIME, ubuntu-lat...	33s
Build AMD64 (./docker/app.Dockerfile, ghcr.io/simstudioai/simstudio, ECR_APP, linux-x64-8-core, b...	3m 27s
Build AMD64 (./docker/db.Dockerfile, ghcr.io/simstudioai/migrations, ECR_MIGRATIONS, ubuntu-lates...	30s
Test and Build / Lint and Test	3m 42s
Test and Build / Build App	2m 29s
Migrate Dev DB	-1s
Build ARM64 (GHCR Only)	-1s
Deploy Trigger.dev (Dev)	-1s
Check Docs Changes	-1s
Build Dev ECR	-1s
Check Desktop Signing Secrets	-1s
Create Desktop Prerelease	-1s
Desktop Prerelease Build	0s
Publish Desktop Prerelease	0s
Prune Desktop Prereleases	0s
Migrate DB / Apply Database Migrations	31s
Promote Images	14s
Process Docs	0s
Create GHCR Manifests	0s
Create GitHub Release	0s
Desktop Release	0s
	12m 20s

Navigation Menu