Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Go KonMari on your SQL
Search
Posedio
PRO
January 27, 2025
Programming
0
22
Go KonMari on your SQL
Queries with the SQL-Police
Posedio
PRO
January 27, 2025
Tweet
Share
More Decks by Posedio
See All by Posedio
Modern data observability
posedio
PRO
0
6
Lost Jobs, Zombie Tasks and AirFlow Nightmares: A debugging Deep Dive
posedio
PRO
0
33
Designing Zero Trust Systems
posedio
PRO
0
24
Platform user's remorse
posedio
PRO
0
130
Rolling out digital receipts on GCP infrastructure
posedio
PRO
0
16
API First revisited - where did we take a left turn?
posedio
PRO
0
64
Solving Multi-Tenant Challenges: Apache Airflow and Cloud Composer in Action
posedio
PRO
0
57
Contract testing with Java
posedio
PRO
0
47
Flink in two nutshells
posedio
PRO
0
69
Other Decks in Programming
See All in Programming
半自動E2Eで手っ取り早くリグレッションテストを効率化しよう
beryu
4
720
テストコードはもう書かない:JetBrains AI Assistantに委ねる非同期処理のテスト自動設計・生成
makun
0
960
楽して成果を出すためのセルフリソース管理
clipnote
0
200
今だからこそ入門する Server-Sent Events (SSE)
nearme_tech
PRO
3
280
Design Foundational Data Engineering Observability
sucitw
3
210
AccessorySetupKitで実現するシームレスなペアリング体験 / Seamless pairing with AccessorySetupKit
nekowen
0
140
知っているようで知らない"rails new"の世界 / The World of "rails new" You Think You Know but Don't
luccafort
PRO
1
540
PostgreSQLで手軽にDuckDBを使う!DuckDB&pg_duckdb入門/osk2025-duckdb
takahashiikki
1
190
The Past, Present, and Future of Enterprise Java with ASF in the Middle
ivargrimstad
0
280
Android StudioのAIコーディングツール、 ぶっちゃけどうなん???
mkeeda
0
160
Introducing ReActionView: A new ActionView-compatible ERB Engine @ Rails World 2025, Amsterdam
marcoroth
0
740
OWASP Kansai DAY 2025.09: OSINTにふれてみよう
deka_morita
0
120
Featured
See All Featured
Principles of Awesome APIs and How to Build Them.
keavy
126
17k
Faster Mobile Websites
deanohume
309
31k
Learning to Love Humans: Emotional Interface Design
aarron
274
40k
The Cult of Friendly URLs
andyhume
79
6.6k
How to Ace a Technical Interview
jacobian
280
23k
Art, The Web, and Tiny UX
lynnandtonic
303
21k
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
127
53k
Exploring the Power of Turbo Streams & Action Cable | RailsConf2023
kevinliebholz
34
6k
XXLCSS - How to scale CSS and keep your sanity
sugarenia
248
1.3M
The Pragmatic Product Professional
lauravandoore
36
6.9k
The Success of Rails: Ensuring Growth for the Next 100 Years
eileencodes
46
7.6k
RailsConf 2023
tenderlove
30
1.2k
Transcript
None
Roadmap 1. What had happened was… 2. Looking under the
Hood 3. Batching the Batch 4. Why you tellin’ me this? 4
What to expect from this talk? 5 Vlad Mihalcea
Do it RIGHT. What had happened was… 01
The Tale of the Item Availability 7
The Architecture 8
Soooooo much Data 9
Soooooo much Data 10
What any seasoned developer would do… 11 More Pods More
Database Connections Check for slow Queries
What any seasoned developer would do… 12
Do it RIGHT. Looking under the Hood 02
DataSourceProxy? 14
DataSourceProxy! 15 Query Logging Slow Query Logging Query Count Tracing
Method
The n+1 Problem 16
The n+1 Problem 17
Do it RIGHT. Batching the Batch 03
Making the Batch batch 19 Align sequence allocationSize with batch
size Implementing Persistable for isNew = true @Embeddable for WHERE (field1, field2) IN (?,?)
Do it RIGHT. Why you tellin‘ me this? 04
Get to know the Tools you inevitably (are doomed to)
work with
Big Thanks! & ways to stalk me… 22