To ensure the best security for check-in Rock will not allow a check-in security code to be reused within a given day. For churches using 3-digit codes that means you are limited to 13,749 codes in a single day. As you close in on that number for a given day the performance of check-in can come to a screeching halt. When the limit is hit it can leave your check-in hanging.
Luckily, this will only impact only the largest of churches and only then in rare cases. You can easily see if you’re coming close using the query below.
FORMAT( [IssueDateTime], 'yyy-MM-dd' ) AS [Day]
, COUNT(*) AS [CheckInCodeCount]
WHERE LEN([Code]) = 3
GROUP BY FORMAT( [IssueDateTime], 'yyy-MM-dd' )
ORDER BY [CheckInCodeCount] DESC
If you find yourself in this situation you have a couple of options:
- The obvious one is to move to using 4-digit check-in security codes. This will give you 331,700 unique codes.
- If you’re coming close to that number and want to buy time before moving to 4-digit codes, you can adjust the types of codes generated for other check-in types like serving teams and events. Often the tags for these types don’t show a code. Moving these to 4-digit codes can save precious 3-digit codes for your children’s check-in.