SQLite Forum

Increasing insert performance of an in-memory db
Login
Often, appends are faster than inserts.

Are your inserts in primary key order? If so, an insert of ~100 records touches a couple of leaf pages (depends on page size, and your string sizes), and about the same number of index pages.

If not, it touches about 100 leaf pages and about 100 index pages.

The thread you referenced was doing inserts in primary key order.