PrismaP
Prisma2y ago
5 replies
RomainB

$queryRawUnsafe takes a long time to respond

Hi !

I have a problem with an SQL query. I'm on a MySQL database, and I'm doing a select with 5 joins via a $queryRawUnsafe, and the query takes 40 seconds. When I use mysql2 or MySQLWorkbench, it takes 4 seconds. I wanted to know if there was a reason, and if there is a way to correct this latency.

prisma version: 5.15.0
MySQL version: 8.0.26
Was this page helpful?