Skip to main content
I
itsm6335
November 21, 2023
Question

Writing data to database via stored Procedure

  • November 21, 2023
  • 3 replies
  • 0 views

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. 

    3 replies

    stefanhelzle0001
    stefanhelzle0001
    Brainy
    November 21, 2023

    Optimizing a stored procedure is something you might want to look for help outside the Appian community.

    With "4Lakh" you mean 400.000, correct?

    karumurua531442
    karumurua531442
    November 29, 2023

    Hi [mention:65eed991805747399c6a97fe8f032893:e9ed411860ed4f2ba0265705b8793d05] 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

    davidj137213
    davidj137213
    Brainy
    November 29, 2023

    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?

    Terms & ConditionsAccessibility statement