SQLite Forum

Understanding memory allocation behavior of SQLite
Login
in-order loading will not eliminate splits, only rebalancing.

See <https://en.wikipedia.org/wiki/B%2B_tree> particularly the section on bulk-loading.

Insertion in sorted (index B-Tree) order has been used since the 1940's to "speed up" table load operations (it is "old technology").