Prisma3mo ago

findMany query is failing as it's breaching planetscale's 100k limit but rawquery is working fine

Is findMany fetch all records before it applies distinct condition? await prisma.table.findMany({ distinct: ['field'] }) is failing with planetscales 100k limit but await prisma.$queryRawSELECT DISTINCT field FROM Table; is passing, why? Actual number of records returned with raw query is 7k. Thanks. version : 5.11.0
0 Replies
No replies yetBe the first to reply to this messageJoin