Archived history.db files should be compressed

lio972 / peerblock

Automatically exported from code.google.com/p/peerblock

Other

1 stars 1 forks source link

Archived history.db files should be compressed #28

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago

Given how large the history.db files can grow, we should consider
compressing these files after moving them to the "archive" directory.

Suggestion sent in via email from Tim M.

Original issue reported on code.google.com by peerbloc...@gmail.com on 29 Jul 2009 at 6:52

GoogleCodeExporter commented 9 years ago

This should be easy'ish. I have a bat that vacuums the history.db file in half a
second. I don't know if it's of any use but I'll paste it anyway.

@FOR %%G IN (*.db) DO ( sqlite3 %%G "VACUUM" )

Original comment by Keefaet...@gmail.com on 2 Aug 2009 at 11:56

GoogleCodeExporter commented 9 years ago

Sorry, I forgot to mention that bat requires the exe of Sqlite in the same 
folder.
You probably knew that already but I'm just making sure.

- Keefa

Original comment by Keefaet...@gmail.com on 2 Aug 2009 at 12:05

GoogleCodeExporter commented 9 years ago

Yup, that "vacuuming" fix was actually implemented in code to fix Bug#29
(http://code.google.com/p/peerblock/issues/detail?id=29).  This bug is to track
automatic zipping of the text-dump of history.db created in the ...\archives
directory if you've told it to "archive and delete" every n days.

Original comment by peerbloc...@gmail.com on 3 Aug 2009 at 2:33

GoogleCodeExporter commented 9 years ago

Leaving this at low priority, but tagging it for Release 1.0 so that if it ends 
up
being an easy fix we just may get it in there.

Original comment by peerbloc...@gmail.com on 12 Sep 2009 at 3:30

Added labels: Milestone-Release1.0

GoogleCodeExporter commented 9 years ago

Not going to make it into 1.0.

Original comment by peerbloc...@gmail.com on 24 Sep 2009 at 1:09

Removed labels: Milestone-Release1.0

GoogleCodeExporter commented 9 years ago

Original comment by peerbloc...@gmail.com on 30 Sep 2009 at 4:34

Added labels: Milestone-1.1

GoogleCodeExporter commented 9 years ago

Re-targetting this to 1.2, since it doesn't look like we'll be getting this 
into 1.1.

Original comment by peerbloc...@gmail.com on 4 Apr 2010 at 3:31

Added labels: Milestone-1.2
Removed labels: Milestone-1.1

GoogleCodeExporter commented 9 years ago

At the very least, instead of zipping, enable the native filesystem compression 
(on filesystems that support it)

Original comment by ca...@strayorange.com on 10 Oct 2011 at 5:11