What is the maximum size limit of process variable in Appian?
Discussion posts and replies are publicly visible
Like the amount of data one variable can hold or the name of the variable ?
amount of data one variable can hold
Hmmm. Not sure but is it just for general knowledge you are asking or have a business use case where you would need to bring in large amount of data in process memory. If it is second then may be think of a different approach of solving the problem.
Fetching data from integration in batches and appended data in process variable and then updating the database at once. So in lower enviroment it is working fine because data limit is around 100 but in production data limit is around 2500. So that's why i want to know what is the max size limit of process variable.
As suggested earlier, try a different approach.
Processes are no good spot to store data. In general.
https://community.appian.com/discussions/f/process/35400/process-variable-size-limit-is-101/137823 , May be you will find something useful in this thread. Answers from the best of best.
The limit is it gonna increase in future?? , Size of the data and time to load the data will decide the fate of the variable.
Keep in mind , Appian isn't meant for heavy processing (It can do , i am sure about it. but at what cost), You can look for alternatives while writing it DB. for example you can go For API sourced records or KAFKA ingestions (Just couple of examples).. so many tools out there will do the work with ease.