On Apr 9, 2019, at 11:39 PM, Peng Yu <pengyu...@gmail.com> wrote: > > Is there a way to make the database file of a size comparable (at least > not over 5 times) to the original TSV table in the .gz file?
Transparent file compression is a feature of several filesystems: NTFS, ZFS, Btrfs, and more: https://en.wikipedia.org/wiki/Comparison_of_file_systems#Allocation_and_layout_policies If you can enable this feature on your existing system or switch to one of the filesystems that do support it, you don’t need a non-default SQLite configuration. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users