Question

Need to update a table with millions of rows present.

Forum|Forum|3 years ago
April 24, 2023
6 replies
0 views

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.

harshitb6843

There are a couple of factors to determine it.

Is this a one-time operation?
If this is not a one-time operation and repetitive instead, then will the data increase over time?
What is the size of each row?
Any specific reason for doing it via Appian and not an SP on the database instead?

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.

pranavk513898Author

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.

harshitb6843

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.

stefanhelzle0001

Brainy

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.

Sign up

Login with SSO

Login to the community

Login with SSO