I've got a list with ~2000 items. I'm hoping to add a daily status update (i.e. Up/Down) to each that i can then use the results to make monthly/yearly/etc.. trend charts. Is there a clean way to do this without lists getting out of control large?
edit: To keep it simple, I don't really need to know how to get the data, just wondering on the best way of setting it up. Lets say I have a thermometer and each day I want someone to check that and add the value to that item on the list (therm. 1) but have access to all the previous values for trending. Now i have 2000 thermometers, what would be a good way to track all that data? All I can come up with is versioning, I'm not sure that would be the best way.