View Single Post
I seem to have a relatively large OF database. I say this because behavior, especially on my iPod Touch, can be very sluggish at times. In order to keep things as quick as possible I archive my completed tasks on a regular basis.

Now I've noticed that whenever I open the archive, it can be VERY sluggish to find what I'm looking for. Searching for a string inevitably starts the colorful wheel spinning for a while.

I have a number of repeated maintenance projects and tasks that I perform and mark as completed every day and every week. I really don't need a record of these items in the archive, and I bet it's all of these completed maintenance items that really slow down work when I'm in the archive.

I was afraid that deleting these items would be as sluggish as a search, but I did some deletion yesterday and I was pleasantly surprised to see that the wait was tolerable. Of course, the best way to ensure that I delete as many of the unnecessary items as possible is to perform a string search, and that's when sluggishness rears its ugly head.

I was wondering if anyone else has large archives that they have to prune? Does anybody have any ideas how to prune effectively and as rapidly as possible?

Any thoughts appreciated!