Which Perfroms Better

• TriggerMe

  SSChampion

  Points: 11752

  More actions

  October 21, 2008 at 4:42 pm

  #192366

  I have an Insert Trigger on a TableA that Inserts a record into TableB whenever an Insert occurs on TableA.

  My question is, is better for performance that I actually perform 2 Inserts in TableA and TableB accordingly as oppossed to having the Insert Trigger on TableA?

  ---

  Kindest Regards,

• RBarryYoung

  SSC Guru

  Points: 143329

  More actions

  October 21, 2008 at 7:26 pm

  #887906

  Yes, two inserts in one transaction is faster than chaining inserts through triggers.

  [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
  Proactive Performance Solutions, Inc. [/font][font="Verdana"] "Performance is our middle name."[/font]