SQL timeouts

[sussexrick]

Deleting a match with a scorecard timed out consistently, but removing the scores and then deleting the remaining match didn't. Removing the scores was slow but worked (as it usually is), and removing the match was fast.

This suggests that smaller, faster operations might be the answer to SQL timeouts and slow performance. Slow scorecard saves are likely down to updating the statistics table. Perhaps relationships should be removed from the statistics table so that records can be removed later from there, after a delete has taken place.

[sussexrick]

SQL profiler showed that comfortably the slowest part of saving match scorecards was updating probability. Changed the probability calculation to remove that update entirely. Profiler now shows every part of the save at <10ms locally, yet it still feels slow in production.