Re: [sqlite] Storing 3-byte ints efficiently

ite-users@sqlite.org Subject: [sqlite] Storing 3-byte ints efficiently I imported a file with ~16.8M rows of 2 integers each (~33.6M ints total) into an SQLite db, no indexes. The ints are all < 16777216 (3 bytes) At 3 bytes/int, I thought the resulting db would be ~100M in size (plus some overhea

[sqlite] Storing 3-byte ints efficiently

I imported a file with ~16.8M rows of 2 integers each (~33.6M ints total) into an SQLite db, no indexes. The ints are all < 16777216 (3 bytes) At 3 bytes/int, I thought the resulting db would be ~100M in size (plus some overhead), but it was actually 274M. How do I make sqlite3 store ints efficie