2 Replies - 3121 Views - Last Post: 22 December 2011 - 04:31 PM

#1 shadachi  Icon User is offline

  • D.I.C Head

Reputation: 15
  • View blog
  • Posts: 141
  • Joined: 25-January 08

One big Transaction or Multiple small Transactions

Posted 22 December 2011 - 12:17 AM

Hi guys , I need help on whether is it feasible to commit one huge transaction per time or do it multiple times.

Lets say around 1000 - 3000 of mixed updating or inserting rows. Which one is preferred ? will it have any impact ?
Is This A Good Question/Topic? 0
  • +

Replies To: One big Transaction or Multiple small Transactions

#2 hackterr  Icon User is offline

  • D.I.C Regular

Reputation: 21
  • View blog
  • Posts: 293
  • Joined: 13-August 09

Re: One big Transaction or Multiple small Transactions

Posted 22 December 2011 - 03:06 AM

Smaller ones are better if the system stays busy with other requests coming in, if its a dedicated system you can consider doing it in one go.
The impact : Smaller transactions would take more time. Larger one would tie up system for other users.
Was This Post Helpful? 0
  • +
  • -

#3 shadachi  Icon User is offline

  • D.I.C Head

Reputation: 15
  • View blog
  • Posts: 141
  • Joined: 25-January 08

Re: One big Transaction or Multiple small Transactions

Posted 22 December 2011 - 04:30 PM

the system i am currently programming will have intervals let say around 30 seconds to 1 min per run . Each run will execute around 1k -3k rows of data. it is a continuous interval , it will be 24/7 non stop.. so which would be better?

Another problem is eating up the Oracle's resources.. that would be troublesome as well .. >_<
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1