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
17
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
Designing Zero Trust Systems
posedio
PRO
0
7
Platform user's remorse
posedio
PRO
0
110
Rolling out digital receipts on GCP infrastructure
posedio
PRO
0
11
API First revisited - where did we take a left turn?
posedio
PRO
0
54
Solving Multi-Tenant Challenges: Apache Airflow and Cloud Composer in Action
posedio
PRO
0
35
Contract testing with Java
posedio
PRO
0
33
Flink in two nutshells
posedio
PRO
0
31
Taming the Codebase: Strategies for Refactoring Legacy Code
posedio
PRO
0
30
Access & Usage Policies and Enforcement: Challenges and Solutions
posedio
PRO
0
26
Other Decks in Programming
See All in Programming
Boost Your Web Performance with Hyperdrive
chimame
1
220
気がついたら子供が社会人になって 自分と同じモバイルアプリエンジニアになった件 / Parent-Child Engineers
koishi
0
230
AI時代のプログラミング教育 / programming education in ai era
kishida
22
16k
複数ドメインに散らばってしまった画像…! 運用中のPHPアプリに後からCDNを導入する…!
suguruooki
0
290
Google Cloudとo11yで実現するアプリケーション開発者主体のDB改善
nnaka2992
1
200
requirements with math
moony
0
470
RCPと宣言型ポリシーについてのお話し
kokitamura
2
110
PromptyによるAI開発入門
ymd65536
1
320
PHPでお金を扱う時、終わりのない 謎の1円調査の旅にでなくて済む方法
nakka
0
540
研究開発と実装OSSと プロダクトの好循環 / A virtuous cycle of research and development implementation OSS and products
linyows
1
160
GDG Super.init(version=6) - From Where to Wear : 모바일 개발자가 워치에서 발견한 인사이트
haeti2
0
500
DevNexus - Create AI Infused Java Apps with LangChain4j
kdubois
0
170
Featured
See All Featured
10 Git Anti Patterns You Should be Aware of
lemiorhan
PRO
656
60k
A designer walks into a library…
pauljervisheath
205
24k
Typedesign – Prime Four
hannesfritz
41
2.6k
Why You Should Never Use an ORM
jnunemaker
PRO
55
9.3k
Unsuck your backbone
ammeep
669
57k
The Pragmatic Product Professional
lauravandoore
32
6.5k
YesSQL, Process and Tooling at Scale
rocio
172
14k
JavaScript: Past, Present, and Future - NDC Porto 2020
reverentgeek
47
5.3k
Dealing with People You Can't Stand - Big Design 2015
cassininazir
366
25k
Imperfection Machines: The Place of Print at Facebook
scottboms
267
13k
4 Signs Your Business is Dying
shpigford
183
22k
Designing for Performance
lara
605
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