Rows vs Columns: The Cache-Line Math That Decides Your Database Layout
A 48-byte record holds a 4-byte column you actually need. Reading that one column through a row-oriented layout pulls twelve times more bytes from memory than the query uses, because the CPU cannot fetch four bytes without fetching the 44 bytes sitting next to them. Multiply that by a hundred milli…
Read the full story at DEV Community — AI ↗
Timeline · 1 report
- 2026-11-17 17:28 · DEV Community — AI
Rows vs Columns: The Cache-Line Math That Decides Your Database Layout