This is related to another question, but I didn't want to hijack the question: http://www.rockrms.com/Rock/Ask/Troubleshooting/Questions/247

We currently take attendance each weekend for our adults, who do not check-in via kiosk. They use a paper form (or digital version, but still manual entry done later). I can see how to take attendance in the web UI section of Groups, but it doesn't seem like it was built with collections this large in mind.  The page takes... awhile to load and times out when we try to save. This is because everybody who has attendance in the group must be a member of the group. Is there a better existing UI block for doing this?  If not I can put on my list creating one but that brings to mind a second question.

Which is currently, when you take attendance it records an Attendance row for everybody in the group. Those that actually attended get marked as DidAttend and those that didn't get marked the other way. With about 50,000 Person records in our database that would be 2.6 million records a year. And we have 4 campuses, and people go between campuses so that potentially means 4 times that count each year. I know for SQL Server itself that is not likely to be a problem, but for Rock is that going to be a potential problem in the future, and/or does anybody have alternate suggestions?  We use Attendance on adults heavily (we get about a 40% return rate on our welcome forms, so it's still a pretty good amount) to determine if somebody should receive help when they call/walk in.