Hi, For doing some backup for my own purpose I was in need to backup a sqlite file. I get some interesing results.
This sqlite is about 20 MB and 164913 lines : % ls -lh /var/spool/bogofilter/wordlist.db -rw------- 1 mail mail 20M 2007-10-02 11:11 /var/spool/bogofilter/wordlist.db After having compress it, it is : % cp /var/spool/bogofilter/wordlist.db /tmp % bzip2 -9p /tmp/wordlist.db % ls -lh /tmp/wordlist.db.bz2 -rw------- 1 root root 6.0M 2007-10-02 12:30 /tmp/wordlist.db.bz2 Size decrease by about a factor 3. Not so bad. Then see next phase. Then, I tried to dump base : % sqlite3 /var/spool/bogofilter/wordlist.db .dump > /tmp/wordlist.sqlite % ls -lh /tmp/wordlist.sqlite -rw-r--r-- 1 root root 15M 2007-10-02 12:33 /tmp/wordlist.sqlite After compressing it (just text there) : % bzip2 -9p /tmp/wordlist.sqlite % ls -lh /tmp/wordlist.sqlite.bz2 -rw-r--r-- 1 root root 1.1M 2007-10-02 12:33 /tmp/wordlist.sqlite.bz2 Here we decrease the size by ~19 the original size ! Maybe could we use that way in the else repo managment ? -- Beber
pgpK7cXWRQCbd.pgp
Description: PGP signature
