Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2004
    Posts
    1

    Unanswered: triggers versus transaction ,Performance wise

    hi can any one tell me which is a better option for a multiuser ,remote database Performance wise........Trigger ,Stored Procedure,OR transaction ......
    I have to find an architecture for audit trail..........
    Poojagolechha

  2. #2
    Join Date
    Feb 2004
    Location
    India
    Posts
    135
    Hi

    look up the following Link!

    http://dbforums.com/arch/57/2003/8/866313

  3. #3
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1

    Re: triggers versus transaction ,Performance wise

    If by "audit trail" you mean tracking inserts, updates and deletes on a table then triggers are the obvious choice. The triggers would likely call a stored procedure that handles the common code.

    Unless of course your DBMS has a built-in way of auditing that doesn't require you to write your own code.

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54

    Re: triggers versus transaction ,Performance wise

    Originally posted by pooja_golechha
    hi can any one tell me which is a better option for a multiuser ,remote database Performance wise........Trigger ,Stored Procedure,OR transaction ......
    I have to find an architecture for audit trail..........
    Poojagolechha
    Better than what? Aside from that, which database engine (DB2, MS-SQL, MySQL, Oracle, etc) are you using now?

    -PatP

Posting Permissions

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