Impact of increasing data size

Hi All,

We need to increase limit to the number of rows returned in the Database Access node from 5000 to 10,000 and increase "conf.data.query.memory.limit" from 1048576 to 2097152. Can any one guide do I need to increase my existing resources like memory size or more CPU power?

Thanks
Rishu

OriginalPostID-267562

  Discussion posts and replies are publicly visible

  • If you are increasing these values due to hitting the upper limits, is it possible to page the data being returned as described in docs.appian.com/.../Query_Rules.html ?

    Increasing these values will cause additional memory usage and have a good chance of adversely affecting overall performance. If the memory usage in your environment is already high, and many processes are using this service, you could expect to have performance issues that might require additional resources to correct.

    If you do go ahead with these updates, it would be best to closely monitor your environment to identify any new issues quickly, as well undertake performance testing, as it is impossible to predict the correct hardware configuration for your usage requirements.

    It's also worth considering the underlying reasons for these changes, and if a more efficient way could be devised, especially if you haven't performed this sort of configuration change before.