https://bugs.gpodder.org/show_bug.cgi?id=1721
Bug #: 1721
Summary: gpodder.net database is huge because vacuum is not
issued regularly
Classification: Unclassified
Product: gPodder
Version: 3.3.0
Platform: PC
OS/Version: MeeGo Harmattan
Status: UNCONFIRMED
Severity: feature request
Priority: low
Component: Application
AssignedTo: [email protected]
ReportedBy: [email protected]
CC: [email protected]
I've been "annoyed" by the large size of the gpodder.net database for a while.
Today I decided to see if sqlite3 vacuum would help.
To my surprise it went from 450M to 20k, now THAT is serious business.
I recommend that some form of gpodder.net vacuum gets integrated into the
application.
sqlite> ~/MyDocs/gPodder $ ll
total 49408
-rw-r--r-- 1 user root 3261440 Nov 28 08:51 Database
drwxrwxrwx 35 user root 65536 Nov 3 18:53 Downloads
drwxrwxrwx 2 user root 65536 Nov 27 01:36 Logs
-rw-r--r-- 1 user root 1509 Jul 1 12:15 Settings
-rw-r--r-- 1 user root 2648 Nov 26 22:34 Settings.json
-rw-r--r-- 1 user root 2048 Nov 18 19:25 flattr.cache
-rw-r--r-- 1 user root 46978048 Nov 28 08:51 gpodder.net
~/MyDocs/gPodder $ sqlite3 gpodder.net
SQLite version 3.7.7 2011-06-23 19:49:22
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> vacuum;
sqlite> ~/MyDocs/gPodder $ ll
total 3584
-rw-r--r-- 1 user root 3261440 Nov 28 08:51 Database
drwxrwxrwx 35 user root 65536 Nov 3 18:53 Downloads
drwxrwxrwx 2 user root 65536 Nov 27 01:36 Logs
-rw-r--r-- 1 user root 1509 Jul 1 12:15 Settings
-rw-r--r-- 1 user root 2648 Nov 26 22:34 Settings.json
-rw-r--r-- 1 user root 2048 Nov 18 19:25 flattr.cache
-rw-r--r-- 1 user root 19456 Nov 28 08:52 gpodder.net
~/MyDocs/gPodder $
--
Configure bugmail: https://bugs.gpodder.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are watching all bug changes.
_______________________________________________
gPodder-Bugs mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/gpodder-bugs
