Results 1 to 2 of 2

Thread: Triggers

  1. #1
    Join Date
    Jul 2002
    Posts
    1

    Unanswered: Triggers

    Has anybody had performance problems using triggers?

    My environment and configurations are:

    AIX, DB2 v7.2 fix pack5
    Trigger after insert that inserts in another table.
    Insert time without trigger is 0.023 sec, and with trigger is 0.45. The action executed by the trigger is an insert, that by itself takes 0.02 too.

    Does anybody have a clue?
    Thanks,

  2. #2
    Join Date
    Oct 2001
    Location
    Bangalore
    Posts
    186
    Definitely the trigger would take more time to execute as it is fired after the insert and it's global triggers that they will take longer than the actual direct insert.
    Prashant

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •