Use a combined template id, party id index in the JSON API #10231
Assignees
Labels
component/json-api
HTTP JSON API
team/ledger-clients
Related to the Ledger Clients team's components.
Milestone
Comments
cocreature
added a commit
that referenced
this issue
Jul 19, 2021
fixes #10231 Before Benchmark (batchSize) (extraParties) (extraTemplates) Mode Cnt Score Error Units QueryBenchmark.run 10000 0 1 avgt 5 0.277 ± 0.037 s/op QueryBenchmark.run 10000 0 10 avgt 5 0.479 ± 0.301 s/op QueryBenchmark.run 10000 0 100 avgt 5 2.131 ± 0.497 s/op After Benchmark (batchSize) (extraParties) (extraTemplates) Mode Cnt Score Error Units QueryBenchmark.run 10000 1 0 avgt 5 0.274 ± 0.141 s/op QueryBenchmark.run 10000 10 0 avgt 5 0.299 ± 0.144 s/op QueryBenchmark.run 10000 100 0 avgt 5 0.281 ± 0.038 s/op changelog_begin changelog_end
6 tasks
cocreature
added a commit
that referenced
this issue
Jul 19, 2021
fixes #10231 Before Benchmark (batchSize) (extraParties) (extraTemplates) Mode Cnt Score Error Units QueryBenchmark.run 10000 0 1 avgt 5 0.277 ± 0.037 s/op QueryBenchmark.run 10000 0 10 avgt 5 0.479 ± 0.301 s/op QueryBenchmark.run 10000 0 100 avgt 5 2.131 ± 0.497 s/op After Benchmark (batchSize) (extraParties) (extraTemplates) Mode Cnt Score Error Units QueryBenchmark.run 10000 1 0 avgt 5 0.274 ± 0.141 s/op QueryBenchmark.run 10000 10 0 avgt 5 0.299 ± 0.144 s/op QueryBenchmark.run 10000 100 0 avgt 5 0.281 ± 0.038 s/op changelog_begin changelog_end
cocreature
added a commit
that referenced
this issue
Jul 20, 2021
* Use a combined template id, stakeholder index fixes #10231 Before Benchmark (batchSize) (extraParties) (extraTemplates) Mode Cnt Score Error Units QueryBenchmark.run 10000 0 1 avgt 5 0.277 ± 0.037 s/op QueryBenchmark.run 10000 0 10 avgt 5 0.479 ± 0.301 s/op QueryBenchmark.run 10000 0 100 avgt 5 2.131 ± 0.497 s/op After Benchmark (batchSize) (extraParties) (extraTemplates) Mode Cnt Score Error Units QueryBenchmark.run 10000 1 0 avgt 5 0.274 ± 0.141 s/op QueryBenchmark.run 10000 10 0 avgt 5 0.299 ± 0.144 s/op QueryBenchmark.run 10000 100 0 avgt 5 0.281 ± 0.038 s/op changelog_begin changelog_end * more disambiguation changelog_begin changelog_end * Update ledger-service/db-backend/src/main/scala/com/digitalasset/http/dbbackend/Queries.scala Co-authored-by: Stephen Compall <[email protected]> Co-authored-by: Stephen Compall <[email protected]>
stefanobaghino-da
added
component/json-api
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
I played around with the idea of adding the template id to the
stakeholdersview and adding a combined index. This seems to work very well and with this I can bump the ACS size by 4x (adding both more parties and more templates) and I get no meaningful slowdown as long as the result size stays the same (measuring db queries).Prototype at https://github.com/digital-asset/daml/commits/json-oracle-experiments-combined
So imho we should pursue this approach.
The text was updated successfully, but these errors were encountered: