The Omni Group
These forums are now read-only. Please visit our new forums to participate in discussion. A new account will be required to post in the new forums. For more info on the switch, see this post. Thank you!

Go Back   The Omni Group Forums > OmniFocus > OmniFocus Syncing
FAQ Members List Calendar Search Today's Posts Mark Forums Read

Sync slow database big Thread Tools Search this Thread Display Modes
Using two macs; iphone. Latest versions of omnifocus.

Don't know how many total tasks I have - a few hundred i would guess (any way to tell?) but my database is 1.1MB; and my mobileme omnifocus file contains lots of zip files.

Archived 600 tasks completed before 9/1; database went from 1.1MB to 900KB (and I should have said that NOW I guess I have a few hundred left - no more). But why 900KB?

I exported to OF format; restored from the export - no change in DB size.

Ran the script procedure, which i have done before and gotten a mobileme directory of only a few files; but mobileme now has about 25 zip files.

Any ideas?
Could you post a list of the file names (.zip and .client) that are on mobileme?
If you are comfortable using the Terminal application, incanting the following will get you a count of all the actions in the current database:

sqlite3 ~/Library/Caches/com.omnigroup.OmniFocus/OmniFocusDatabase2 'select count(*) from Task';
(press the "return" key after typing it all to cause the command to be executed, or better yet, copy and paste it from this message)

Do you have attachments for any of your actions? Some audio or photo attachments from your iPhone, or file or email attachments from the desktop can make the database size swell quickly. Unfortunately I don't know of a convenient way to figure out which actions are contributing the most to the file size.

As for the number of zip files in the MobileMe database, that will go up by 1 each time you add a new action, until all of the OmniFocus clients can agree that that action is "old news" so to speak (they've all got it synced into the "past history" part of the database, which is the .zip file that is much larger than the rest, typically). You have 3 OmniFocus clients, and there are apparently some optimizations yet to be made where the squashing down of the database doesn't happen as often as it should when you have more than just 2 clients. You can use the Coalesce database script posted elsewhere to do this manually, but if you aren't suffering from slow syncs on the iPhone, I wouldn't bother. My reading of the discussion is that the most important thing you can do to keep the sync speed acceptable is to make sure your clients get synced often, so that when you make changes on one client, those changes get synced to the other clients before you use one of the others to make additional changes.

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
"database on your iPhone is incompatible with the sync database" error message kevinwest66 OmniFocus Syncing 36 2011-05-08 04:32 PM
Webdav sync of MBP seems very slow defilmj Other WebDAV 2 2008-11-19 12:08 PM
BUG: extremely slow sync time to iDisk jbleffert iDisk/MobileMe/.Mac Syncing 23 2008-08-04 12:09 PM
.ofocus file oddity - why so slow to sync? bigcloits OmniFocus 1 for Mac 6 2008-05-27 02:18 PM

All times are GMT -8. The time now is 09:52 PM.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2020, vBulletin Solutions, Inc.