[chrisblair]

Is there a help article on Cleanup issues?

Particularly is there is optimum number of items beyond which the performance, especially on iPhone, is compromised?

Is there an easy way to discover how many items in the database? At the moment I export all folders to Excel and look there to see a data dump. Also enables me to create special reports.

[curt.clifton]

Do you mean Rebuilding? Cleanup is the term used in OF for refreshing the current view, for example, to hide completed items. Rebuilding is the term for coalescing a series of separate transaction into a single database state. I believe that OF 1.1 automatically rebuilds the database as all the clients synchronize to a series of transactions.

Or do you mean Archiving? Archiving moves completed items to a separate archive database that isn't sync'd to the phone. Archiving seems to be a work in progress currently.

[chrisblair]

Thanks Curt.

I had in mind all those issues, plus rebuilding of indexes, if that is applicable with OF.

You have explained the differences between these procedures, and I have learnt some important information from this post.

I started with dBase II on an Osborne computer with a 5 inch screen 25 years ago - now I use an iPhone with a smaller screen and OF. Maintaining the database was an important issue then.

Plus ça change, plus c'est la même chose.

[Toadling]

If you're comfortable using Terminal, you can use this SQLite query to count the number of actions indexed by OmniFocus:

sqlite3 ~/Library/Caches/com.omnigroup.OmniFocus/OmniFocusDatabase2 'select count(*) from Task';

-Dennis