skj2001
PPrisma
•Created by skj2001 on 6/16/2024 in #help-and-questions
Does Raw Queries Hit Read Replica ?
Hey folks
There are places where we use raw sql queries which are unavoidable , we have a read replica setup as well we did that as suggested in the documentation with prisma/extension-read-replicas package
My question is when using raw queries will the query hit Master DB or read replica.
here is a sample query we use it as per the documentation but mentioning here as well -
await prismaClient.$queryRaw<any>(Prisma.sql SELECT * from "TableName" );
i have tried doing load test on my api end point when using raw query but didn't get any conclusion can someone please help me with this.
Thanks in advance 🙂
2 replies