August 17, 2009 at 4:32 pm
Calling a webservices using trigger is safe? or may lead to a performance issue?
August 18, 2009 at 12:15 pm
I wouldn't recommend it. Anything that happens in a trigger happens within the scope of the INSERT/UPDATE/DELETE transaction so if the web service call fails the transaction will roll back. That isn't the only issue. Since the web service call could take extra time you will introduce major concurrency issues in your database as the resources being used within the transaction will remain locked until the transaction completes.
Basically in triggers you want to avoid any actions that require resources outside the current database/server. Check out this article on Trigger basics.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 18, 2009 at 12:18 pm
Just found this thread which asks the same question so you might want to check it out as well.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 18, 2009 at 12:24 pm
Thanks Jack, I will definitely check the link that you gave:-D
Well Appreciated
Shyrill
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply