Tag
This article demonstrates that pre-sorting random data before inserting into SQLite can improve insert performance by 2-3x, by leveraging the B+ Tree's ordered nature and reducing page splits.
This paper proposes out-of-place write optimizations for database systems to fully leverage SSD performance, achieving 1.65-2.24x throughput improvement and 6.2-9.8x reduction in flash writes on OLTP benchmarks.