[QUOTE=omnibob;63364]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.
[/quote]
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.

[quote]
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.
[/quote]
Yeah, I am in a similar situation.
[quote]
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.
[/QUOTE]
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.

Hey all, I just wanted to drop back in and mention that my synchronizations have indeed been much faster after dropping and reestablishing the link. Thought it might be worth mentioning, since it's a 3 minute fix instead of a 1 hour one.

[QUOTE=jasonclarke;63367]Hey all, I just wanted to drop back in and mention that my synchronizations have indeed been much faster after dropping and reestablishing the link. Thought it might be worth mentioning, since it's a 3 minute fix instead of a 1 hour one.[/QUOTE]
The main reason I describe the slower method is that a mistake simply means that it doesn't compact, whereas methods involving wiping out the database on one or more clients offer the opportunity to really screw things up.

Good point.

[QUOTE=omnibob;63364]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.
[/QUOTE]

Bob, does this help?

Select Perspectives -> Completed items
Select View -> Grouping -> Completed

You now have a window showing all your completed actions, with the least recently completed items at the bottom. If you enter the name(s) of your single action list(s) into the toolbar search field, that'll hide the vast majority of the actions you want to leave in your database. (If you have a list with a short name like "health", it'll appear in the list.)

Still, it should be possible to do a good chunk of pruning in this view. Maybe save it as a perspective until we're able to implement the archive style that would work better for you?

[QUOTE=whpalmer4;63366]Didn't you have an iPhone at one point?[/QUOTE]

Yes, thanks. 173 projects and 3131 actions stored in 224 zip files.

[QUOTE=whpalmer4;63366]
Sure it is, it's called the Archive command :)

It should be possible to write an Applescript [...] [/QUOTE]

Interesting idea, thanks.

Bob

[QUOTE=Brian;63376]Bob, does this help?

Select Perspectives -> Completed items
Select View -> Grouping -> Completed[/QUOTE]

Yes, thanks, that is very helpful.

[QUOTE=Brian;63376]If you enter the name(s) of your single action list(s) into the toolbar search field, that'll hide the vast majority of the actions you want to leave in your database.[/QUOTE]

I have about 50 SALs, so I'm just looking at them manually. What would help more would be to be able to sort by project/SAL.

[QUOTE=Brian;63376]Bob, does this help?

Select Perspectives -> Completed items
Select View -> Grouping -> Completed[/QUOTE]

Yes, thanks, that is very helpful.

[QUOTE=Brian;63376]Maybe save it as a perspective until we're able to implement the archive style that would work better for you?[/QUOTE]

Done. I'll see how this goes. Thanks again.

Bob