This talk details how Tencent's iOS engineers tackled SQLite performance bottlenecks by redesigning multithreaded concurrency, optimizing Busy Retry handling, leveraging WAL and mmap, and applying low‑level I/O and lock improvements, resulting in dramatic reductions in UI lag and CPU waste for heavy‑use users.
This article explains how WeChat's iOS client tackled SQLite performance bottlenecks by introducing multi‑handle threading, enabling WAL mode, redesigning the Busy‑Retry mechanism, and applying I/O enhancements such as preserving WAL size and mmap usage, resulting in over 90% reduction in perceived lag.
This article explains SQLite's Virtual Database Engine (VDBE) architecture, its LR‑based grammar compilation using Lemon, compares it with Lua's virtual machine, and details the instruction set, execution flow, and stack versus register implementations.
This article introduces SQLite, a lightweight ACID‑compliant relational database widely used in mobile devices, detailing its zero‑configuration design, key features, limitations, transaction and locking mechanisms, and the Write‑Ahead Logging mode that enables concurrent reads and writes.
This article details a multi‑stage performance overhaul of a large‑scale chat application's SQLite database, covering trace‑based I/O analysis, view caching with Fragments, table‑splitting experiments, index size reduction, and the development of a PageTracer tool to quantify page‑level gains.