DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Fast Commit

  1. #1
    Join Date
    Jul 2001
    Posts
    52

    Dear Friends

    I have read on one book following paragraphs.

    Redo log buffer may be flushed before commit, the size
    of transaction does not affect the amount of time needed for an actual commit operation.

    can any body ple. explain above statement in details

    Rakesh Sanghvi

  2. #2
    Not really that well I can't, but it's saying that.

    No matter how big an insert or an update, once the changes have been written to that database.

    A commit will take the same amount of time whether you updated 1 row or 1,000,000 rows.

    The statement itself will take longer but the commit will take the same amount of time.

    The redo log buffer contains entries to be written to redo log files.

    When the buffer fills it writes it's info to the log file. You can force this to happen by flushing the buffer.

    This again will not affect the time it takes to commit the change.

    Hope that helps.

Posting Permissions

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


Click Here to Expand Forum to Full Width