|
|
|
Forum Member
Group: Forum Members
Last Login: 10/29/2009 1:54:07 PM
Posts: 5,
Visits: 11
|
|
| Hi Nick, compact feature is causing 100% fragmentation and journal file is not "deleted". I tried to compact the DB with external program and FeedDemon showed 0% fragmentation and no error. But then I tried to compact the DB with FeedDemon and 100% fragmentation was back. Thanks
Petr |
|
|
|
|
|
NewsGator
Group: Administrators
Last Login: Yesterday @ 8:29:11 PM
Posts: 1,679,
Visits: 41,581
|
|
| Hi Petr, If FeedDemon is reporting 100% fragmentation after compacting it, then there must be a bug in the way I determine the percentage of fragmentation. I'll dig into my code and make sure this is fixed before the final release. Thanks,
Nick Bradbury
Nick's Blog
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 10/29/2009 1:54:07 PM
Posts: 5,
Visits: 11
|
|
| OK, just a note: when I compact (vacuum) DB using SQLite Expert program, then the journal file is gone and FeedDemon reports 0% fragmentation. But when I use compact in FeedDemon, journal file is still there after compact. So probably it's not a cosmetic problem, but the real one.
|
|
|
|
|
NewsGator
Group: Administrators
Last Login: Yesterday @ 8:29:11 PM
Posts: 1,679,
Visits: 41,581
|
|
| FeedDemon doesn't delete the journal file when you compact the database - but now that I think about it, it probably should. I'll add this to the next build. Thanks,
Nick Bradbury
Nick's Blog
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 10/29/2009 1:54:07 PM
Posts: 5,
Visits: 11
|
|
| It seems, that journal files are still not deleted and I think that journal files should not exist when FeedDemon is not running. Because journal files are used for Transactions. So you have probably some open transactions after FeedDemon exits. I'm using also SQL lite and I don't have problem with journal files existance. Thanks
|
|
|
|
|
NewsGator
Group: Administrators
Last Login: Yesterday @ 8:29:11 PM
Posts: 1,679,
Visits: 41,581
|
|
FeedDemon uses PRAGMA journal_mode=PERSIST, which means the journal file won't be deleted automatically. This is done to avoid problems caused by AV software which detects new files and temporarily locks them so it can scan them right after they're created.
Nick Bradbury
Nick's Blog
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 10/29/2009 1:54:07 PM
Posts: 5,
Visits: 11
|
|
|
|
|