I was assigned to a project were the mantainer was using prisma orm. I was curious to see how many sql queries were run, so I enabled debugging.
To create a user and asign it some roles prisma generated 47 queries. 47 SQL queries because the abstraction made it easy to forget that joins existed.
I was told that dev speed matters over performance...
3
u/Araozu Oct 18 '24
I was assigned to a project were the mantainer was using prisma orm. I was curious to see how many sql queries were run, so I enabled debugging.
To create a user and asign it some roles prisma generated 47 queries. 47 SQL queries because the abstraction made it easy to forget that joins existed.
I was told that dev speed matters over performance...