New Approach to Resolve objectrelational impedance mismatch

on YouTube ↗01h 01m

" summary

Shows concrete wins: Ruby on Rails with Active Record and Postgres is generating 1,000 database calls per screen for some controllers, identified by PG Badger as top offenders (one query runs ~500k times and totals hours). The approach is to split logic—disassemble methods, build a single Postgres query or function, and validate with dark testing—cutting calls to ~1–5 and reducing execution time about threefold.

AI-written summary · about

" chapters (9)

1. 0:00Intro
2. 2:03Database Application Performance
3. 13:33What is Impedance Mismatch?
4. 18:02Development Standards & Performance
5. 31:40Logic Split Methodology
6. 38:03Under the Hood: Database Calls
7. 44:26Traditional Object-Oriented Approach
8. 54:23Agile Technology
9. 58:19Aknowledgements

" related talks

• 42mHolistic Database Application TuningHenrietta Dombrovskaya, Grant Evans · PostgresOpen 2014
• 26mBiggish Data With Rails and PostgresqlStarr Horne · Cascadia Ruby 2014
• 46mUse PostgreSQL, not Rails, to make Rails Faster!Dan McClain · PostgresOpen 2014
• 31mUsing Databases to pull your applications weightHarisankar P S · RailsConf 2018
• 30mPuny to Powerful PostgreSQL Rails AppsAndrew Atkinson · RailsConf 2022
• 41mUsing Databases to Pull Your Application WeightHarisankar P S · Southeast Ruby 2017
• 46mBeyond Good and ORMsKerri Miller · Ancient City Ruby 2015
• 34mBeyond CRUD: the PostgreSQL techniques your Rails app is missing.Shayon Mukherjee · RailsConf 2023