Skip to Content

Error Identification and Performance tuning

Hi Guys,

I am very new to hana. So please pardon my ignorance.

1st issue is regarding movement of records from one table to a node via view and then inserting data from that node to another table through insert statements .We are executing all these steps through a Stored Procedure which also takes care of any exception due to invalid data. Suppose we are moving 100 records, and 54th, 55th, 96th and 97th records are invalid data and fails the stored procedure. While error handling, only 54th record is captured in error log while other 3 are not identified in first run.. So to identify other 3 invalid record, stored procedure needs to be called 3 more times which, later on fails all three times and all three records are captured in each run respectively . Is there any way that all error records can be identified at first run itself.

My another question is what are the steps for performance tuning the Code? Please provide me any link or source which I can go through.

Add comment
10|10000 characters needed characters exceeded

0 Answers