CODEWITHSUNDEEP
.netsqlsql-serversql-server-2008c#-4.0
Anshuman Jasrotia
Anshuman Jasrotia

Reputation: 3175

Do triggers have any performance impact on the stored procedure

I am creating a stored procedure that updates a single record. Based on that record very large number of records are recalculated and updated in another table. Currently I am using a trigger for this purpose. I just want to know if triggers have any performance issues that I should look into. Also does stored procedure returns the result after the trigger is completed or stored procedure returns result even if trigger is still running.

Upvotes: 0

Views: 126

Answers (1)

solaimuruganv
solaimuruganv

Reputation: 29707

result of stored procedure depends on the trigger statement

     BEFORE or  AFTER

regarding the performance it has both pros and cons, refer

Upvotes: 3

Related Questions