[scaleslea]

My wife and I have been having lots of problems with long sync times both on the iPhone and the desktop client when syncing to iDisk. It wasn't until today when I finally ran the Coalesce database script that we finally got sync times measured in seconds instead of minutes. All this time we've been wondering what was wrong with OmniFocus and why it was syncing so slowly.

So I've been wondering, what kind of average sync times is everyone else getting?

Today my sync time went down to 20 seconds from 2-5 minutes.

Doc

[ohammersmith]

I'm finding that I have to run the coalase database script anytime I do a lot of editing on my desktop OmniFocus. I've been tracking the size of the folder on the server, along with the types of files in it. Yesterday I was catching up on my weekly review (3 weeks behind. bleah.) and my file exploded up to 3 megabytes. No amount of syncing could it it to come down very much. This made my iPhone sync times a copule minutes, or more.

These are the graphs I have from my monitoring system.





I think the solution is to sync less often. Very rarely is the every minute sync going to be useful in my use cases. I still have to be sure to sync before I close my laptop, or lock my iPhone. All every minute does is create a crazy number of transactions to catch up on... you can see from the graphs that I got up to 600 transaction files.

[whpalmer4]

If you don't have some stale client entries (check the Show Clients display in the Sync preferences in OmniFocus), two syncs on all of your devices separated by an hour should cause your database to automatically compact.

[ohammersmith]

Originally Posted by whpalmer4

two syncs on all of your devices separated by an hour should cause your database to automatically compact.

Why the hour? I guess there's something OF is waiting for that I don't realize?

I'm pretty sure I did that yesterday, but I can't guarantee it. A number of the transactions were at least 2 hours old, I do know that.

[whpalmer4]

That's the way the code makes sure there isn't a really slow client sync in progress, or some other condition that would make it unsafe to compact the database. If everything is synced up twice, separated by at least an hour, the compaction code should run.

[ohammersmith]

Cool. Next time it blows up to 3 meg, I'll be more patient and see if the database compcats itself.