On Thu, Aug 10, 2017 at 03:36:31PM +0200, Clemens Ladisch wrote: > x wrote: > > I’m thinking about this more from the gain in speed rather than saving > > space. > > Database performance is usually limited by I/O, i.e., you gain speed by > saving space.
Then proper compression (e.g., with zlib) will be much better for you than what you're trying to do. I don't know how to get SQLite3 DBs compressed though, short of writing your own VFS (one might already exist) or hosting on ZFS (which works very well). Nico -- _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users