Slide 1

Slide 1 text

No content

Slide 2

Slide 2 text

Roadmap 1. What had happened was… 2. Looking under the Hood 3. Batching the Batch 4. Why you tellin’ me this? 4

Slide 3

Slide 3 text

What to expect from this talk? 5 Vlad Mihalcea

Slide 4

Slide 4 text

Do it RIGHT. What had happened was… 01

Slide 5

Slide 5 text

The Tale of the Item Availability 7

Slide 6

Slide 6 text

The Architecture 8

Slide 7

Slide 7 text

Soooooo much Data 9

Slide 8

Slide 8 text

Soooooo much Data 10

Slide 9

Slide 9 text

What any seasoned developer would do… 11 More Pods More Database Connections Check for slow Queries

Slide 10

Slide 10 text

What any seasoned developer would do… 12

Slide 11

Slide 11 text

Do it RIGHT. Looking under the Hood 02

Slide 12

Slide 12 text

DataSourceProxy? 14

Slide 13

Slide 13 text

DataSourceProxy! 15 Query Logging Slow Query Logging Query Count Tracing Method

Slide 14

Slide 14 text

The n+1 Problem 16

Slide 15

Slide 15 text

The n+1 Problem 17

Slide 16

Slide 16 text

Do it RIGHT. Batching the Batch 03

Slide 17

Slide 17 text

Making the Batch batch 19 Align sequence allocationSize with batch size Implementing Persistable for isNew = true @Embeddable for WHERE (field1, field2) IN (?,?)

Slide 18

Slide 18 text

Do it RIGHT. Why you tellin‘ me this? 04

Slide 19

Slide 19 text

Get to know the Tools you inevitably (are doomed to) work with

Slide 20

Slide 20 text

Big Thanks! & ways to stalk me… 22