Search
Star
Feedback
Setup for Free
© 2026 Hedgehog Software, LLC
Twitter
GitHub
Discord
System
Light
Dark
More
Communities
Docs
About
Terms
Privacy
findMany query is failing as it's breaching planetscale's 100k limit but rawquery is working fine - Prisma
P
Prisma
•
2y ago
ab3290
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
SELECT DISTINCT field FROM Table
;
is passing
, why
?
Actual number of records returned with raw query is 7k
.
Thanks
.
version
: 5
.11
.0
Prisma
Join
The official Discord server of Prisma! Find us online at prisma.io
9,819
Members
View on Discord
Resources
ModelContextProtocol
ModelContextProtocol
MCP Server
Recent Announcements
Similar Threads
Was this page helpful?
Yes
No
Similar Threads
rawQuery compilation
P
Prisma / help-and-questions
16mo ago
findMany() vs findMany({...})
P
Prisma / help-and-questions
13mo ago
prisma.transaction.findMany() not working
P
Prisma / help-and-questions
2y ago
Stalling Transaction but Query without it works
P
Prisma / help-and-questions
2mo ago