Database
SQL PARTITION BY Demystified: The Hidden Mechanics of Window Frames
Understand how PARTITION BY truly works in SQL and unpack the logic hidden behind OVER (PARTITION BY ... ORDER BY ...).
Database Isolation Levels: Why Phantom Read Doesn't Happen in MySQL
A deep dive into database isolation levels and MySQL Gap Lock.
Hibernate Second-Level Cache with EhCache
The time and cost of accessing the database over the network is much higher than the time to access the server's internal memory.
How To determine the order of indexes when using Composite Key
Why the column order of a composite key matters, and how to order it by analyzing the WHERE clause.