Hello Community,I need to upgrade a table where there are more than 1 million rows available, I want to know can this operation be performed at Appian end, I am thinking of retrieving the data in batches of 5000, that batch needs to go through encryption/decryption function. Since this processing needs to be done at Appian end, so cant use Stored Procedures for this. Will Appian be able to handle such load ?Any suggestions will be helpful ?Thanks in advance.
Discussion posts and replies are publicly visible
There are a couple of factors to determine it.
Doing it via SP will anyway be faster and more promising considering you have a huge data and you need to perform the update operation.
You write "Since this processing needs to be done at Appian end". Seems like there are no options. Just make sure to do this during low-activity times and add a bit of a delay to the loop.
Hello Harshit,Thanks for quick reply, I will try to elaborate: 1. Planning to create it as a utility, so it can be reused in future.2. Yes data will increase overtime.3. Probably 4-5 columns will be queried as one row.4. we need to apply new appian encrytion on these queried data, and need to store it back again, I am not sure whether encrypting the data can be done through Stored Procedure.
In that case, as Stefan said, you can do it during nonworking hours, when there are close to no people working and the least active processes.
I suggest to redesign this and get rid of the need for the update and that encryption thing.
That's the main reason we are creating this utility for, replacing data which was encrypted by old plugin and re encrypt it with the newer function available.