Friday, May 17, 2013

Disadvantages of using SQL-Server triggers?

Posted by Rahul Kharde at 4:14 AM
  • It is easy to view table relationships, constraints, indexes, stored procedure in database but triggers are difficult to view and track. 
  • Triggers run on every update made to the table therefore it adds more load to the database and cause the system to run slow.
  • Triggers execute invisible to client-application application so it is difficult to figure out what happens at the database layer.
  • It is hard to follow their logic as it they can be fired before or after the database insert/update happens.
  • Triggers run every time when the database fields are updated and it is overhead on system. It makes system run slower 
  • It is easy to forget about triggers and if there is no documentation it will be difficult to figure out for new developers for their existence.

If you enjoyed this post and wish to be informed whenever a new post is published, then make sure you subscribe to my regular Email Updates. Subscribe Now!

Kindly Bookmark and Share it:



Have any question? Feel Free To Post Below:


Popular Posts

Recent Comments

© 2011. All Rights Reserved | Help to understand .Net | Template by Blogger Widgets

Home | About | Top