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?