The disassembled bird will always require more tar to coat than the assembled bird. This is because the disassembled bird will have a greater surface area to coat with tar than the assembled bird. This is a fact of physics which, although you may try as you might, you cannot change (unless of course you are Q in which case you may simply change the gravimetric constant of the universe).
You should probably perform "data normalization" on the contents of your file. This is likely to result in the greatest reduction in space used that anything else in the multiverse ... --- The fact that there's a Highway to Hell but only a Stairway to Heaven says a lot about anticipated traffic volume. >-----Original Message----- >From: sqlite-users [mailto:sqlite-users- >boun...@mailinglists.sqlite.org] On Behalf Of Peng Yu >Sent: Tuesday, 9 April, 2019 23:39 >To: SQLite mailing list >Subject: [sqlite] compressed sqlite3 database file? > >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
