Post reply

TRIGGER FOR UPDATE is getting big

  • September 23, 2003 at 2:47 pm

    #358356

    I'm working on UPDATE TRIGGER

    It's getting more than 200 lines.

    It has 4 IF UPDATE() checks

    and each IF UPDATE() check

    has two INSERTS.

    I started worrying about performace.

    Because the TRIGGER is now pretty big.

    Anybody had any performance issues due to

    big TRIGGERS?

  • September 25, 2003 at 4:57 am

    #475765

    Sounds big, but it really matters more how long it takes and what the possibility is that the code executing will get blocked by someone else. Definitely worth stress testing a little. How about posting the code, maybe we can offer suggestions.

    Andy

    http://www.sqlservercentral.com/columnists/awarren/

    Andy
    Connect with me on LinkedIn

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply