Ken K#1
TLDR: We store scoresheets in a temporary area and then record it into a more permanent database when both teams finalize.
The scoresheet is stored in a fast area of memory on the server. While this "fast" memory is robust, it does not have the degree of permanence that a "slower" storage medium has.
Storing it in the "fast" memory allows for quicker updates and changes while a match is in progress. It is lighter on the system to retrieve, update, and write changes to the matches.
When both teams finalize, the system will check that the data is valid. If it is valid and both teams have valid signatures, the system:
\
- Retrieves all data from the "fast" memory.\
- Parses out each frame (who won, who played, frame number)\
- Records in a separate table the frame information (home or away win)\
- Records in a separate table the players of the frame\
- Tallys the score, determines a winner and...\
- Finally records the who won the match and how many points they are allotted.