2 ms·
Note that this does not defragment the storage on disk, just the internal SQLite pages. So it's not a complete solution.
by gcp 15y ago
Note that this does not defragment the storage on disk, just the internal SQLite pages. So it's not a complete solution.
- nirbheek 15y agoActually, that command will also rewrite the entire .sqlite file, and if you have enough free space, the filesystem will most likely rewrite it in a contiguous manner. I tested this with filefrag.