SharePoint 2010: Strategies for Handling Historical Data in Custom Lists

This Wiki page discusses strategies for dealing with historical data. It was originally inspired by Paul Stork's response at http://social.technet.microsoft.com/Forums/en-US/sharepoint2010customization/thread/31cf9e61-4faf-4832-aefc-a110d7d93ad2.

• If the historical data doesn’t take up much space, leave it in the original list.
• Turn on versioning if you want to track the history of individual list items.
• If the history involves different records, leave them in the list and sort the view on the date of the history with the most recent at the top.

Finally, the most common option: eventually archive the items to a different site collection in a different content database if you need to save space.