Post

in SQLite, INT PRIMARY KEY and INTEGER PRIMARY KEY are NOT the same. INT PRIMARY KEY creates a secondary B-tree index and requires 2 seeks per lookup. INTEGER PRIMARY KEY aliases directly to the internal 64-bit rowid B-tree key: single seek, zero extra index, half the storage