Note: In SQLite rowid tables are implemented as B+-Trees where all content is stored in the leaves of the tree, whereas WITHOUT ROWID tables are implemented using ordinary B-Trees with content stored on both leaves and intermediate nodes.

UUIDs take 5 to 16x times slower to insert. UUID without row id in SQLite are only 2 to 3 times slower.

Not random insertion is also useful to write in a database efficiently.