Consistent final data in final computed scores report

[jpschewe]

There have been a few cases where scores are being entered while the final computed scores report is run. Due to how the database needs to store data and then read parts back this can cause a report to be inconsistent with itself, showing a team with a high performance scores, but still a low rank.

[jpschewe]

I created a web servlet that displays the max performance score for all teams, sleeps for 10 seconds and then repeats for 5 times.
While that page as generating I inserted a new high score for a team.

With the default locking the changed score was seen.

When creating a transaction the changed score was still seen.

However when setting the transaction isolation level to repeatable read, then the changed score was not seen.

This suggests that I could have the final computed scores report be something like this:

1. get connection
2. set transaction isolation level to repeatable read
3. turn off auto commit
4. execute summarize scores using this connection
5. generate the report with this transaction
6. commit the transaction
7. render the PDF

However I don't know what this would to performance.

Executing the score summarization automatically for any report might be a good idea though.