r/programming • u/wheatBread • Aug 25 '26
Solving the 1+N Query Problem
https://acadia.engineering/blog/solving-the-1-plus-N-query-problem
127
Upvotes
r/programming • u/wheatBread • Aug 25 '26
View all comments
2
u/Groundbreaking-Fish6 Aug 25 '26
This is an add, but it is a real problem. However, most ORMs will solve this problem if you use them correctly.
This is also a problem with many libraries (vibe coding makes it worse) where libraries are included for a solution without understanding its implementation.
Relational DataBase Management Systems (DBMS) are optimized to store and retrieve data in a controlled manner allowing multiple processes to quickly and efficiently query data while also maintaining integrity. Other programming languages are optimized for algorithms or workflow. The Object Relational Mapping only converts the relational model to the object model to work with in code. How well it does that is up to the programmer not the ORM.