Memory threshold error while querying database

Certified Senior Developer

Hi,

We have a requirement to fetch some records for a particular filter (service name from DB) and show it on the grid to the user. The issue is we have a large number of records in DB, which are more than 20+ lakhs and goes on increasing.

While fetching the data from table I am facing the memory threshold error. I am using batch size as (1,-1), because I need to show all the data in the grid.

so, My question is how many records Appian can handle & how many records can be fetched at a time.

NOTE: i am not using Record Type, directly fetching it from DB

Also can we query more than 20 lakhs record from a record type, 

  Discussion posts and replies are publicly visible

Parents Reply Children
No Data