InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Why Do We Need Batch Updates? |
|
Answer» Let's say there are 100 RECORDS need to be insert. If we execute normal statemets the no of transactions will be 100 (in TERMS of connection making to DB). USING batch updates we can add 100 rec to batch and the no of transactions will be only one in this CASE. This will reduce the burdon on db, which is very costly in terms of RESOURCES. Let's say there are 100 records need to be insert. If we execute normal statemets the no of transactions will be 100 (in terms of connection making to DB). using batch updates we can add 100 rec to batch and the no of transactions will be only one in this case. This will reduce the burdon on db, which is very costly in terms of resources. |
|