top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

What happens if you increase commit intervals and also decrease commit Explain grouped cross tab?

0 votes
186 views
What happens if you increase commit intervals and also decrease commit Explain grouped cross tab?
posted Jul 28, 2015 by Sachin

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

if commit interval is set to high value, performance will be high. if commit is given for every 1000 rows say for eg,it will affect the performance badly

if you have increased your commit interval to ~25000 rows the session will run faster but when your session fails at 24000th record you will not have any data in your target.

When you decrease your commit interval to ~10000 rows your session will be slow when compared to previous but if the session fails at 24000th record you will lose only 4000
records

answer Jul 31, 2015 by Shweta Singh
...