# How well does the json-api query store perform under heavy workloads?

**URL:** <https://forum.canton.network/t/how-well-does-the-json-api-query-store-perform-under-heavy-workloads/1906>\
**Category:** App Development\
**Tags:** daml-on-sql, json-api, query-store\
**Created:** [January 7, 2021, 12:14pm UTC](https://forum.canton.network/t/how-well-does-the-json-api-query-store-perform-under-heavy-workloads/1906 "2021-01-07T12:14:50Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![anthony](https://yyz2.discourse-cdn.com/flex034/user_avatar/forum.canton.network/anthony/32/419_2.png) [@anthony](https://forum.canton.network/u/anthony)\
**Post date:** [January 7, 2021, 1:20pm UTC](https://forum.canton.network/t/how-well-does-the-json-api-query-store-perform-under-heavy-workloads/1906/2 "2021-01-07T13:20:38Z")

</div>

This is an excellent set of questions @lashenhurst and certainly something we should have in more detail. I’ve split the questions up into separate threads so that each can be answered independently and more easily digested and responded to by others.

The other topics are here:

> [@Is it possible to estimate growth of the JSON API query store as the ledger itself grows?](https://discuss.daml.com/t/is-it-possible-to-estimate-growth-of-the-query-store-as-the-ledger-itself-grows/1907):
>
> Is it possible to estimate growth of the query store as the ledger itself grows?

> [@Should the query store and postgres database be on the same instance?](https://discuss.daml.com/t/should-the-query-store-and-postgres-database-be-on-the-same-instance/1908):
>
> When using DAML-on-SQL, is it viable to have the query store as a database in the same postgres instance as the ledger itself? Is that recommended or should it be avoided?

---

_[View the full topic](https://forum.canton.network/t/how-well-does-the-json-api-query-store-perform-under-heavy-workloads/1906)._