Skip to Main Content

Java Database Connectivity (JDBC)

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Strategy to process millions of records in minutes

2811206Dec 9 2014 — edited Dec 10 2014

Hi all,

Need help finding a strategy that allow process 12 millions of records in less than 1 hour. Each record can be modified by business rules. In this process are performed insert, update and select in other 3 tables.

The end result of this process is update monetary fields (for the calculations is used BigDecimal) of records in another table.

This process is part of the migration of Cobol to Java/Oracle. In cobol this process takes approximately one hour.

Is it possible?

Sorry my english and thank you very much.

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 7 2015
Added on Dec 9 2014
6 comments
2,300 views