I need to delete all documents in a folder that are over 10 days old. What is the best/most efficient way of getting the collection to delete without having to loop through the view. I cannot guarantee that the database is FT Indexed so using FTSearch to create the collection is not an option. Thanks.
Subject: Delete All Documents Older than 10 Days - Best Method?
If performance is what you are after, check out the ‘Document collections’ section in IBM - United States if you have not already. Awesome resource.
As for FT, well, you can always detect it with IsFTIndexed (property of NotesDatabase class) and use CreateFTIndex/RemoveFTIndex methods of NotesDatabase class as appropriate.
Number of docs in the db is what must be considered in the first place.
Tom