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
19
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
Lost Jobs, Zombie Tasks and AirFlow Nightmares: A debugging Deep Dive
posedio
PRO
0
20
Designing Zero Trust Systems
posedio
PRO
0
22
Platform user's remorse
posedio
PRO
0
120
Rolling out digital receipts on GCP infrastructure
posedio
PRO
0
16
API First revisited - where did we take a left turn?
posedio
PRO
0
62
Solving Multi-Tenant Challenges: Apache Airflow and Cloud Composer in Action
posedio
PRO
0
51
Contract testing with Java
posedio
PRO
0
43
Flink in two nutshells
posedio
PRO
0
57
Taming the Codebase: Strategies for Refactoring Legacy Code
posedio
PRO
0
42
Other Decks in Programming
See All in Programming
slogパッケージの深掘り
integral0515
0
120
知って得する@cloudflare_vite-pluginのあれこれ
chimame
1
120
「次に何を学べばいいか分からない」あなたへ──若手エンジニアのための学習地図
panda_program
3
640
階層化自動テストで開発に機動力を
ickx
1
410
テストから始めるAgentic Coding 〜Claude Codeと共に行うTDD〜 / Agentic Coding starts with testing
rkaga
16
6k
テスト駆動Kaggle
isax1015
1
880
AI コーディングエージェントの時代へ:JetBrains が描く開発の未来
masaruhr
1
210
テスト環境にCDを導入してみた
yasaigaoisi
0
100
TypeScriptでDXを上げろ! Hono編
yusukebe
3
860
20250708_JAWS_opscdk
takuyay0ne
2
150
効率的な開発手段として VRTを活用する
ishkawa
1
180
構文解析器入門
ydah
7
1.8k
Featured
See All Featured
Six Lessons from altMBA
skipperchong
28
3.9k
Principles of Awesome APIs and How to Build Them.
keavy
126
17k
4 Signs Your Business is Dying
shpigford
184
22k
Fashionably flexible responsive web design (full day workshop)
malarkey
407
66k
How GitHub (no longer) Works
holman
314
140k
The Language of Interfaces
destraynor
158
25k
Rebuilding a faster, lazier Slack
samanthasiow
83
9.1k
Chrome DevTools: State of the Union 2024 - Debugging React & Beyond
addyosmani
7
760
ピンチをチャンスに:未来をつくるプロダクトロードマップ #pmconf2020
aki_iinuma
126
53k
ReactJS: Keep Simple. Everything can be a component!
pedronauck
667
120k
The Power of CSS Pseudo Elements
geoffreycrofte
77
5.9k
Designing for Performance
lara
610
69k
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