The following is an instance of a recurring type of problem. So I need to find a systemic rather than a particular solution.
I receive weekly tracking reports. When I search for “tracking report” I get hundreds of hits. Most are visual clutter. Those from the last 12 months need to be readily available. Those older than 3 years need to be kept, just in case, but will almost certainly never be opened again. Those from 1-3 years old are needed rarely enough that I would prefer for them not to appear in routine searching, but are needed frequently enough that I don’t want to have to do digital archaeology to find them. This raises two questions.
What is the best practice for files that you truly wish to retire and archive? Do they go into a directory not indexed by EF? Do they go into a separate EF database? Is there some better way?
What is the best practice for semi-archived files, which you don’t wish to see in the instant search results, but which you do wish to be able to find within a minute or two, should the need arise?