Tagged articles

page

3 articles · Page 1 of 1

Jul 2, 2026 · Backend Development

Why Spring Boot Prefers Slice Over Page for Massive Data Sets

The article analyzes Spring Data JPA's Page and Slice pagination options, explains the hidden COUNT(*) overhead of Page, demonstrates both approaches with code examples, compares performance and UX impacts, and provides guidance on when to choose Slice for large‑scale or infinite‑scroll scenarios.

PerformanceSpring Bootbackend

0 likes · 11 min read

Why Spring Boot Prefers Slice Over Page for Massive Data Sets

Tongcheng Travel Technology Center

Jul 19, 2023 · Databases

InnoDB Storage Model Overview and Internal Structures

This article explains how InnoDB stores data on disk, describing tablespaces, segments, extents, pages, row formats, record headers, page directories, B+‑tree indexes, and the differences between clustered and secondary indexes, with examples and diagrams to illustrate each component.

B+TreeInnoDBMySQL

0 likes · 26 min read

InnoDB Storage Model Overview and Internal Structures

Liangxu Linux

Dec 5, 2022 · Databases

How Does MySQL Store a Row? Inside InnoDB Files, Pages, and Row Formats

This article explains where MySQL keeps its data files, how InnoDB organizes tablespaces into segments, extents, pages and rows, details the Compact row format—including variable‑length field length lists, NULL‑value lists, and hidden fields—and clarifies the limits of VARCHAR and row‑overflow handling.

Database StorageExtentInnoDB

0 likes · 22 min read

How Does MySQL Store a Row? Inside InnoDB Files, Pages, and Row Formats