Hi Team,
I was facing some issue while querying and performing larger data such as approx 1M+ data at a time. Considered I'm querying data from approx 5 table using some filter to reduce some search results and storing in seperate variable with the help of index() function. Even I'm having more data and I'm performing approximate n time (rare case n^2 times) as looping so Appian expression rule was failing shows as one pop up with please try later in the code such approx 502, 504. Is there any limit in Appian hold particular level of data or no such limit? Anyone has any idea is there any better way to handle this larger case of data...
Thanks and Regards,
Vigneshkumar Radhakrishnan
Discussion posts and replies are publicly visible
You are bound by memory. Appian has a circuit breaker to avoid you bringing it down.
I would suggest filtering directly in your query. Don't use index or forEach on such large datasets.
Even after multiple filters, there was more data so not able to access at the same time. Can you share bit more about Appian circuit breaker?
What are you using this query for?
Are you displaying a grid? In that case, you should use paging.
not in grid, Im querying data for trying to use in process models
You shouldn't be querying large sets in a process model. Why are you doing this?