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
24
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
What is a platform?
posedio
PRO
0
40
Unsealing Vault
posedio
PRO
0
11
Modern data observability
posedio
PRO
0
15
Lost Jobs, Zombie Tasks and AirFlow Nightmares: A debugging Deep Dive
posedio
PRO
0
35
Designing Zero Trust Systems
posedio
PRO
0
29
Platform user's remorse
posedio
PRO
0
140
Rolling out digital receipts on GCP infrastructure
posedio
PRO
0
21
API First revisited - where did we take a left turn?
posedio
PRO
0
65
Solving Multi-Tenant Challenges: Apache Airflow and Cloud Composer in Action
posedio
PRO
0
58
Other Decks in Programming
See All in Programming
CSC305 Lecture 05
javiergs
PRO
0
220
CSC509 Lecture 04
javiergs
PRO
0
300
NixOS + Kubernetesで構築する自宅サーバーのすべて
ichi_h3
0
1k
組込みだけじゃない!TinyGo で始める無料クラウド開発入門
otakakot
0
300
monorepo の Go テストをはやくした〜い!~最小の依存解決への道のり~ / faster-testing-of-monorepos
convto
2
500
uniqueパッケージの内部実装を支えるweak pointerの話
magavel
0
1k
チームの境界をブチ抜いていけ
tokai235
0
180
技術的負債の正体を知って向き合う
irof
0
180
開発生産性を上げるための生成AI活用術
starfish719
3
1.2k
All About Angular's New Signal Forms
manfredsteyer
PRO
0
180
フロントエンド開発のためのブラウザ組み込みAI入門
masashi
0
110
タスクの特性や不確実性に応じた最適な作業スタイルの選択(ペアプロ・モブプロ・ソロプロ)と実践 / Optimal Work Style Selection: Pair, Mob, or Solo Programming.
honyanya
3
180
Featured
See All Featured
Put a Button on it: Removing Barriers to Going Fast.
kastner
60
4k
YesSQL, Process and Tooling at Scale
rocio
173
14k
Refactoring Trust on Your Teams (GOTO; Chicago 2020)
rmw
35
3.2k
KATA
mclloyd
32
15k
Sharpening the Axe: The Primacy of Toolmaking
bcantrill
46
2.5k
XXLCSS - How to scale CSS and keep your sanity
sugarenia
248
1.3M
Fireside Chat
paigeccino
40
3.7k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
253
22k
The MySQL Ecosystem @ GitHub 2015
samlambert
251
13k
Side Projects
sachag
455
43k
Gamification - CAS2011
davidbonilla
81
5.5k
Music & Morning Musume
bryan
46
6.8k
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