Its good to see that you are willing to optimize your code and in my opinion
Originally Posted by techlearner
1. Use an MSSQL stored procedure with all the validation checks and call in the event.
would be the fastest. This is because when you have the SP the database engine optimizes it for better performances. Read the Stored procedures
and you will get more idea about the SP.