[Leaderboard] generating test data is slow at 1 entry per second

[TjerkNan]

Describe the bug When using the mix script to generate submissions, only one submission per second is created in both DEV and OPS environment. The ops environment has better performance SKU (faster database) but no impact on performance.

I'm putting this on medium because this slow behaviour could be a sign of something more important so it doesn't need to be solved but it would be recommended to investigate sooner rather than later.

To Reproduce Generate test data on an environment with devops script like this Notice syntax, second to last number is leaderboard id and last number is amount of records to create.

time ./manage-leaderboard-submissions ops create tcl 1 20

Expected behavior Generating values should take mere seconds.

Screenshots Result for 20 records on OPS environment real 0m22.629s user 0m2.742s sys 0m0.517s

Desktop (please complete the following information): N/A

[mellelieuwes]

@vloothuis this is de transaction:

See: Systems.Graphite.Gen