Re: Question about efficiency

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Simon Harvey (simon.harvey_at_the-web-works.co.uk)
Date: 02/27/04 

Date: Fri, 27 Feb 2004 17:10:34 -0000

Hi,

By putting my commands into a transaction do you just mean that I say
something like

(Pseudo Code)
Begin Transaction
    Do Loads of Update statements one after another
End Transaction

Why would doing the work in a transaction make the code more efficient?

Thanks for your help!

Simon

Relevant Pages

  • Re: Transaction Problem, part two..
    ... Pseudo Code of problem: ... If I move the ProcessOrder call to just before the PrintInvoice call, ... ProcessOrder procedure with its own transaction protection and that too is ...
    (borland.public.delphi.database.ado)
  • Reuse Transaction?
    ... after committing a transaction I'd like to create a new transaction on an existing connection. ... Here's some pseudo code I'm using ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: CommitBatchSize vs. CommitBatchThreshold for transactional dis
    ... " I issued the same 7 update statements as in test 1. ... saw one batch with 6 update statements (all with the same transaction ... ID) followed by a second batch with 1 update statement (different ... commitbatchthreshold would as its 11 commands. ...
    (microsoft.public.sqlserver.replication)
  • Re: Objects new in Collection
    ... Unfortuanely I can not persist changes immediately to the DB becuase ... everything must be performed within a transaction as one "unit of ... I wasn't clear on what I need for the "IsNew" portion of the ... Loads comment from DB with ID ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: Newbie ADO.Net Question.
    ... > individual INSERT, DELETE and UPDATE statements, according to what has ... > locking, you can effect pessimistic locking by associating the INSERT, ... > DELETE, AND UPDATE commands with a Transaction object, which has the added ... >> I need to do an update, select, update statement as a single unit using the ...
    (microsoft.public.dotnet.framework.adonet)