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?
Hi ,
You may create a stored procedure and create an expression rule to fetch that data using executeStoredProcedure function.Thank You.
And may you please provide some more details that how you are using that data?I mean, in a grid, and so on?
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?
Hi Ravi, Im trying to use large amount of Number(Integer) from table and trying to access in process model. Can you please share more about stored procedure and executeStoredProcedure function?
May you please provide some more details that how you are using that data in the process model and why you need whole data at once?And also you may try again that query by apply selection on it (only keep those fields/columns that you need in the process).Thank You.
And talking about stored procedure, so in stored process you can join the tables and pass parameters for filtering and all.And call that stored procedure in Process model also with smart service or function.Thank you.