A database trades off space for performance and functionality. It is expected that a database with indexes that you can randomly access is going to take more space than the raw data, let alone a compressed version of the raw data.
On Wed, Apr 10, 2019 at 12:39 AM Peng Yu <pengyu...@gmail.com> wrote: > I have some TSV table in .gz format of only 278MB. But the > corresponding sqlite3 database exceeds 1.58GB (without any index). 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? Thanks. > > -- > Regards, > Peng > _______________________________________________ > 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