Thread: Database Size
View Single Post
That's the right file. The sync method doesn't affect the size of the file.

One thing that can take up some space is extensive notes in the actions. Another is a bunch of perspectives that need to save the ordering of the projects/actions.

What does the iPhone report on the Settings page for the size of your database (actions, projects, zip files)?

Why don't you do a Show Package Contents on the database file, sort by size, and report the size of the top 10 files? There will be one bigger one that has a filename starting with 0000 -- that's all the consolidated transactions. The other .zip files are either transactions or client files (the latter are small and relatively few in number).

My guess is that your database hasn't compacted recently, and due to a bug in the shipping iPhone app, it processes the unincorporated transactions in a very inefficient manner, which makes the sync seem quite slow. Getting the database to compact will help, if that is the case. Answers to my questions above will show if my hunch is correct.