Prisma's query engine fetches entire tables inefficiently, causing expensive data reads and performance degradation
7/10 HighPrisma's Rust-based query engine performs application-level joins by fetching entire tables and merging results in memory rather than using optimized database-level SQL joins. This approach wastes bandwidth and becomes prohibitively expensive for teams paying per-row-read to database providers like PlanetScale, and is especially problematic at scale.
Sources
Collection History
the way Prisma Works under the hood with its rust binary is that it fetches both table if you want to create something like an SQL join... the Prisma just goes ahead and fetches from the one table fetches from the other merges them together resulting in a pretty inefficient data querying... that becomes especially painful when you're paying your database provider... based on how many rows are read.