~/talk

Mastering JPA Performance

Talkat Oracle Code One 2018 · 2018-10-22..10-25· [databases]
links:none on file
slides:none on file

Finds that most slowness comes from excessive SQL interactions and shows fixes that actually cut statements and time: switching the table generator default allocationSize=1 to a larger allocation (e.g. 100) reduces tens of thousands of ID fetches, enabling JDBC batching with batch size 100 and sorting by entity removes repeated flushes and yields 20–50x faster writes, using prefetch with IN and LEFT JOIN FETCH makes reads deterministic, and network latency can turn optimized local runs of seconds into minutes across continents. Tools: JPA/Hibernate, H2/Oracle/MariaDB, Docker, JUnit, Hibernate stats.

AI-written summary · about

  1. 0:00Introduction to JPA performance
  2. 3:57Analyzing database creation
  3. 7:14Optimizing ID generation
  4. 11:58Batching and database interaction
  5. 21:09Reading entities efficiently
  6. 24:29Advanced querying techniques
  7. 29:16Data-dependent performance
  8. 33:41Updating and flushing entities
  9. 37:40Latency and caching considerations
  10. 41:59Conclusion and best practices
~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.