Progress! Hooray :)
Jennifer, it'd be interesting to know how many actions you have in your database, and how it compares to the recommendation of 1,000 or so. You can find this out in the Terminal by entering the following command:
Code:
sqlite3 ~/Library/Caches/com.omnigroup.omniFocus/OmniFocusDatabase2 'select count(*) from Task';
or downloading and running the attached Applescript. The number printed out is the count.
Knowing how big the data file is post-compaction might help, too. I'm a little suspicious that you might have some large attachments in there, as my data file before compaction was recently about 8 MB for 8,000+ actions spread over 4,000+ files, and you said yours was 6x that size! I'm not sure the desktop app would work very well either with that kind of a burden, based on my experience.