As I said in my previous email, I have a 13GB database that transparently compresses to 800MB. Not sure if it got through, didn't get replies to my last two emails.
Wout. On Wed., Apr. 10, 2019, 5:04 p.m. Warren Young <war...@etr-usa.com> wrote: > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users