New Topic/Question
Reply
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 ?
2 Replies - 2767 Views - Last Post: 22 December 2011 - 04:31 PM
MultiQuoteReplies To: One big Transaction or Multiple small Transactions
#2
hackterr
- D.I.C Regular
Reputation: 21
- 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.
The impact : Smaller transactions would take more time. Larger one would tie up system for other users.
Was This Post Helpful?
0
#3
shadachi
- D.I.C Head
Reputation: 15
- Posts: 137
- 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 ..
Another problem is eating up the Oracle's resources.. that would be troublesome as well ..
Was This Post Helpful?
0
Page 1 of 1
|
|
| 