/plushcap/analysis/edgedb/why-orms-are-slow-and-getting-slower

Why ORMs are slow (and getting slower)

What's this blog post about?

Object-relational mapping (ORM) libraries are popular due to their usability benefits but come with important performance tradeoffs that are often poorly understood and quantified. To evaluate the performance of major ORM libraries, a new benchmarking tool called IMDBench has been open-sourced. The results show that ORMs have some unfortunate characteristics such as requiring multiple queries to fetch all the data needed for complex operations. This is why they are perceptually slower than raw SQL. However, it's important to understand the limitations of ORMs if you wish to make an informed decision regarding these technologies.

Company
EdgeDB

Date published
March 29, 2022

Author(s)
Colin McDonnell

Word count
1818

Hacker News points
9

Language
English


By Matt Makai. 2021-2024.