Cyndicate Enclosure Issue – Help?
Posted October 5th, 2009 @ 12:27pm by Erik J. Barzeski
Can those of you with copies of Cyndicate try this please and report back?
These are the commands you'll enter in the Terminal (with Cyndicate not running). If you're uncomfortable in the Terminal, skip this post entirely.
First, note the size of your "Cyndicate.cyndata" file.
% cd Library/Application\ Support/Cyndicate/Cyndicate.cyndata/
% sqlite3 dataStore.sql
SQLite version 3.6.12
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select count(*) from ZENCLOSURE where zarticle isnull;
We're interested in the number you get here. I got 222 and that was after only a short time using the database.
sqlite> delete from ZENCLOSURE where zarticle isnull;
sqlite> vacuum;
sqlite> .quit
If you'd like to help, please report your total and your before/after sizes in the comments below. Thanks.
Donate Life
Posted 07 Oct 2009 at 12:37pm #
Old file size: 25.2 MB
New file size: 24.1 MB
The select statement revealed 9201 ZENCLOSUREs.
Posted 07 Oct 2009 at 2:46pm #
Start file size for the DB: 32313344
Count from query: 35495
File size after vacuum: 26798080
Posted 07 Oct 2009 at 5:15pm #
694 zenclosures.
29 MB before and after.
Posted 07 Oct 2009 at 9:29pm #
Before: 1669901129 (1.56G)
sqlite> select count(*) from ZENCLOSURE where zarticle isnull;
5096876
After: 849292105 (810Mb)
Posted 11 Oct 2009 at 5:13pm #
Count: 32049
Before: 55.7Â MB
After: 51.3Â MB
My database dates from beta testing Cyndicate (unless I started from scratch at some point, I don't remember exactly).