View previous topic :: View next topic
|
Author |
Message |
Sriram K
New User
Joined: 17 Feb 2009 Posts: 32 Location: Bangalore
|
|
|
|
Hi,
I have coded a batch program which reads records from a table in a cursor. It will process around 2000 records a day. Program doesn't read records from a file. So should i use checkpoint logic in my program or can i use a commit after each record is processed.
Will committing after each record will affect performance? Or do we have any specific scenarios to go for checkpoint logic? Any disadvantages in using chekpoint logic?
Can anyone suggest on this. |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
Suggest you consider using no commit/checkpoint. If you do, then you need to consider how you will handle a restart.
If you just let the process run from start to finish, these considerations go away. |
|
Back to top |
|
|
Sriram K
New User
Joined: 17 Feb 2009 Posts: 32 Location: Bangalore
|
|
|
|
Thanks for your suggestion |
|
Back to top |
|
|
|