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
18
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
56
Taming the Codebase: Strategies for Refactoring Legacy Code
posedio
PRO
0
42
Other Decks in Programming
See All in Programming
Yes, You Can Work on Rails & any other Gem
kaspth
0
100
Google Agent Development Kit でLINE Botを作ってみた
ymd65536
2
260
型で語るカタ
irof
0
710
DMMを支える決済基盤の技術的負債にどう立ち向かうか / Addressing Technical Debt in Payment Infrastructure
yoshiyoshifujii
4
420
AI駆動のマルチエージェントによる業務フロー自動化の設計と実践
h_okkah
0
240
A full stack side project webapp all in Kotlin (KotlinConf 2025)
dankim
0
150
Hack Claude Code with Claude Code
choplin
7
2.6k
可変変数との向き合い方 $$変数名が踊り出す$$ / php conference Variable variables
gunji
0
190
MDN Web Docs に日本語翻訳でコントリビュートしたくなる
ohmori_yusuke
1
130
「次に何を学べばいいか分からない」あなたへ──若手エンジニアのための学習地図
panda_program
3
350
Claude Code + Container Use と Cursor で作る ローカル並列開発環境のススメ / ccc local dev
kaelaela
12
7.1k
フロントエンドのパフォーマンスチューニング
koukimiura
5
2.1k
Featured
See All Featured
Faster Mobile Websites
deanohume
308
31k
A Modern Web Designer's Workflow
chriscoyier
695
190k
StorybookのUI Testing Handbookを読んだ
zakiyama
30
5.9k
Measuring & Analyzing Core Web Vitals
bluesmoon
7
520
Writing Fast Ruby
sferik
628
62k
CoffeeScript is Beautiful & I Never Want to Write Plain JavaScript Again
sstephenson
161
15k
Making the Leap to Tech Lead
cromwellryan
134
9.4k
Design and Strategy: How to Deal with People Who Don’t "Get" Design
morganepeng
130
19k
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
eileencodes
26
2.9k
Agile that works and the tools we love
rasmusluckow
329
21k
ReactJS: Keep Simple. Everything can be a component!
pedronauck
667
120k
The Cult of Friendly URLs
andyhume
79
6.5k
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