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.$queryRaw
SELECT DISTINCT field FROM Table;
is passing, why?
Actual number of records returned with raw query is 7k.
Thanks.
version : 5.11.00 Replies