[whpalmer4]

Originally Posted by omnibob

1.8MB (running on a 2.4 GHz. Intel Core 2 Duo, 2GB RAM). I don't know how to get # of actions and zip files.

Didn't you have an iPhone at one point? The settings page will reveal those two numbers. Otherwise, you can install the Count Database Items script Imentioned earlier in this thread.

I can't use the Archive function as currently implemented, because I have active projects that I need to retain completed actions from in my 'live' file, no matter how long ago the actions have been completed.

I have been manually copying over completed projects to my archive file, which helps some.

Yeah, I am in a similar situation.

If there is/would be a way for me to be able to filter down to actions completed based on completion date, I could focus on my SAL containers, then select those actions, and also move them to my archive. That would reduce the size of my db a lot. But I don't think that filter is available.

Sure it is, it's called the Archive command :)

It should be possible to write an Applescript that takes a selected list of actions and removes everything from the selection that is newer than a specified date. You could then select one of your SAL containers, invoke the script, and drag what's left off to the corresponding spot in the archive, then delete them from the active database. I suspect the script could be enhanced to do the whole job, though I haven't tried moving stuff to the archive in Applescript, or deleting actions from the database.