On Jun 23, 2011, at 10:18 AM, Stephan Beal <sgb...@googlemail.com> wrote:
> Hi, all!
>
> Today i saw a curious thing: i store 440kb of wiki files in an sqlite3 db
> and the db file is only 400kb.
>
> HTF can that possibly be?
>
> After poking around i found that the wiki files actually total 360kb (when i
> added up their sizes manually, as opposed to using 'df' to get it), and the
> extra 80kb were from the hard drive's large block size (slack space reported
> by 'df').
>
> Kinda funny, though, that sqlite3 actually decreases the amount of storage
> required in this case.
Lots of small files will take up more space because of the fixed minimum block
size. For large corpuses this won't matter. Putting them all in one db makes
logistical management easier, but you will lose the ability to update just a
single file individually. I used to store all my wiki files (punkish.org) in
one SQLite db, but now I have them as separate files which allows me to just
ssh and edit a single file easily. Six of one, and all that.
>
> --
> ----- stephan beal
> http://wanderinghorse.net/home/stephan/
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
