
Vladimir Sitnikov
14:50
01 April
40 min
Choose Wisely: SQL, ORM, or JSON?
Which method of data retrieval in PostgreSQL works faster: several simple SQL queries, ORM tools (Hibernate, jOOQ), or a single query with JSON aggregation?
In this talk, we will explore several data extraction strategies, compare their performance, and discuss potential pitfalls. We will look at how ORM tools handle one-to-one and one-to-many relationships, the overhead that arises when using JOINs, and why JSON-based retrieval might be the most efficient solution. Real benchmarks, the pros and cons of each approach – all of this will be covered in our research.