Loading

Performace Issues with stored Procedure

Sailaja Y

16y4.7k

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,

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Vikrant More14y ago
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.