Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
commit interval
- Thread starter kpmINFO
- Start date
hi,
I think there won't be much issues by increasing the commit interval. But the potential problem if the session fails after loading some of the records say 25000 then it will rollback & even if the records loaded are correct u need to reload. But incase of 10000 then the no. of records is small & same case after 25000 if session fails then 2 commit would have occured so only 5000 only will be roll backed.
to my knowledge this is the possible issue that can occur.
Regards
VLN
I think there won't be much issues by increasing the commit interval. But the potential problem if the session fails after loading some of the records say 25000 then it will rollback & even if the records loaded are correct u need to reload. But incase of 10000 then the no. of records is small & same case after 25000 if session fails then 2 commit would have occured so only 5000 only will be roll backed.
to my knowledge this is the possible issue that can occur.
Regards
VLN
- Status