View Single Post
I go through a process on a monthly basis to try to keep my database at a manageable size. I used to be able to get it down to 200-300k, but now it won't reduce below about 600k. That seems high to me but I can't figure out how to get it any lower.

I'm going to outline what I do, if anyone has suggestions on things I can do to reduce it further, I'd be grateful.

1. Sync both desktop and iphone versions
2. Move old data to archive
3. Double check to ensure that are no attachments. I have my preferences set to not import attachments, so currently there are none in my database.
4. Sync both versions again, just to be safe
5. Do a backup
6. Do a file/export to file type omnifocus document
7. Restore this exported file
8. Do another backup so now I can compare sizes of the backup from step 5 and this one. This is where I'll typically see the size go from about a 1mb to 600 kb.
9. Sync again

so I am getting a file size reduction, but it still seems large to me. Any suggestions on reducing it further?