Pushdown Optimization — 2 Technical Articles

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

Boost MySQL Queries: How GaussDB’s Limit‑Offset Pushdown Cuts Execution Time

Big Data Technology & Architecture

Nov 26, 2020 · Big Data

Understanding Apache Parquet: Architecture, Data Model, and Performance

This article provides a comprehensive overview of Apache Parquet, covering its modular architecture, nested data model, striping/assembly and definition level algorithms, file format details, push‑down optimizations, performance benchmarks, and the project's evolution within the big‑data ecosystem.

Columnar StorageParquetPerformance

0 likes · 18 min read

Understanding Apache Parquet: Architecture, Data Model, and Performance