Hi Team,
Currently am writing data to table from stored procedure.
Can someone help that what is the best way to improve its performance, Since in Healthcheck its coming as High Risk.
Number of records added is around 4Lakh.
Discussion posts and replies are publicly visible
Optimizing a stored procedure is something you might want to look for help outside the Appian community.
With "4Lakh" you mean 400.000, correct?
Hi David Actually it is huge data. Just a thought from my side. Can you try this way by sending data to stored procedure in batches using pagination and staging table in between .It might take little while to complete the process but it could reduce the load lo stored procedure. Since after one batch is uploaded we will delete the data in staging table and load the staging table with next set of data and run procedure again. Could you try this method
Can you explain a little bit the risk please? I guess that you are using the SP inside a PMO, and the risk is about the AMU of the process, rigth?