Post

I reduced the size of a SQL table and its indexes from 300 MB to 70 MB: 1. No timestamps (16 bytes less per row) 2. No ID column (natural primary key, so one less index) 3. CREATE TABLE name (...) WITHOUT ROWID (SQLite only)

RoRvsWild

@rorvswild.com

The improvement is significant because I/O operations are smaller and the data is more easily cached by the file system. Of course, not all models are suitable for these tips. The more rows a table has, the more important it is to carefully choose the column types.

3/9/26, 1:59 pm0 reposts0 likes

No replies yet.