Writing data to database via stored Procedure

Question

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.

Abhishek Karumuru · Answer

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