I need to perform a function in a Spring and Hibernate project, to which I must update some information from all records in my table. The idea is to load the records into the application, process the data based on some values from those records, and then persuade the entire mass of data.
The values to be updated are different for each record, and depend on the data already persisted in each one.
The table contains some 200,000 records, and I'd like to know the best strategy for me to be able to perform this data loading, processing, and persistence without bottlenecks in my application and database.