1
Answer

Performace Issues with stored Procedure

Sailaja Y

Sailaja Y

15y
4.3k
1

Hi,
In my application i have around 5000- 6000 records that get updated through a stored procedure on a daily basis.
Now I have a requirement where I to insert this data into some other new tables.
Iam planning to use one more stored procedure that will be called within the first stored procedure.
Will there be any performance issues?If yes, is there any method I can implementsuch that I have to call only one storedprocedure from UI?
 
Any help would matter a lot
 
Regards,
Answers (1)
0
Vikrant More

Vikrant More

NA 1.5k 166.3k 12y
Insted of creating another stored procedure why dont you create the DML Trigger on Update it will insert the records into new table. this will not harm on you performance i think.