3 ms·
There is no concept of SQL-level joins in Prisma. This was one of the most shocking revelations to us. In some queries we inspected that supposedly should have
by DemocracyFTW2 3y ago
There is no concept of SQL-level joins in Prisma. This was one of the most shocking revelations to us. In some queries we inspected that supposedly should have used SQL Joins or subqueries, we discovered that at a low level, Prisma was fetching data from both tables and then combining the result in its “Rust” engine. This was a path for an absolute trash performance.
This is terrifying. OTOH they were coming from MongoDB, so what were they expecting? A sane DB layer? /s
- sgarland 3y agoThis is absolutely awful, and anyone who chose it as an ORM either didn’t read the docs, or didn’t understand the implications. “I’ll just SELECT * from all these tables, and figure out what I want in my app.”
- DemocracyFTW2 3y agoRight, who needs an SQL `join` when you can do all your `join`s in Ruby, JS, Python whatever? What? SQL?