Huawei Cloud Developer Alliance
Aug 29, 2024 · Databases
Boost MySQL Queries: How GaussDB’s Limit‑Offset Pushdown Cuts Execution Time
GaussDB for MySQL introduces a Limit‑Offset pushdown optimization that moves offset calculation to the InnoDB storage engine, eliminating unnecessary row transfers and index‑back‑table lookups, thereby dramatically reducing query latency for large offsets as demonstrated by TPC‑H benchmarks.
Database PerformanceGaussDBMySQL
0 likes · 13 min read
