Skip to content
Tagged articles

SQLite

205 articles · Page 3 of 3
Tencent TDS Service
Tencent TDS Service
Aug 25, 2016 · Databases

How We Supercharged SQLite on iOS: Threading, I/O, and Real‑World Performance Gains

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.

MultithreadingPerformance OptimizationSQLite
0 likes · 17 min read
How We Supercharged SQLite on iOS: Threading, I/O, and Real‑World Performance Gains
WeChat Client Technology Team
WeChat Client Technology Team
Aug 15, 2016 · Databases

Boosting SQLite Performance on iOS: Threading, I/O, and Busy Retry Optimizations

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.

SQLiteconcurrencydatabase optimization
0 likes · 14 min read
Boosting SQLite Performance on iOS: Threading, I/O, and Busy Retry Optimizations
MaGe Linux Operations
MaGe Linux Operations
Aug 25, 2015 · Databases

Why SQLite Might Be the Perfect Database for Mobile Apps

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.

SQLiteTransactionsWrite-Ahead Logging
0 likes · 11 min read
Why SQLite Might Be the Perfect Database for Mobile Apps
WeChat Client Technology Team
WeChat Client Technology Team
Aug 24, 2015 · Databases

How We Boosted SQLite Chat Performance: Fragment Caching, Table Splitting, and Index Refactoring

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.

AndroidDatabase IndexingFragment
0 likes · 21 min read
How We Boosted SQLite Chat Performance: Fragment Caching, Table Splitting, and Index Refactoring