View Single Post
Sounds like a lot of unnecessary work! OmniFocus should do most of this for you automatically if you just make sure that your devices sync regularly, and you make a habit of syncing before making changes when switching from one device to another. You still need to run the Archive command manually, of course.

"Wasted" space in your database comes predominantly from two things:
  1. completed actions and projects you no longer need
  2. transaction history awaiting compaction

Archiving gets rid of #1. The most effective way of tackling #2 is to sync all your devices, then on the Mac, unregister all of the clients (including the Mac) from the Show Clients display in the Sync preferences. Click the sync button, which will write out a fully compacted database to the server, then sync the other devices, making sure to choose to keep the sync database when asked.

You don't use attachments, apparently, but for anyone reading this who does, note that deleting an action with an attachment (or just the attachment) does not reclaim the space until those transactions have been compacted out of the history. As long as there is a device which hasn't been synced to know about the transaction deleting the attachment, the attachment has to be kept in the database.

It is possible to make an action grow to appreciable size by pasting a lot of heavily formatted text into the notes. I don't know of a convenient way to find "large" actions like this.