How to accelarate insert into database in java?
I need insert many rows from many files like:
Identifier NumberValue
For each row I am looing if already exists in database row with
Identifier, if exists I will take its NumberValue and add NumberValue from
arriving row and update database. I have found that lookup in database for
each row (few millions of records total) takes many time. Does it make
sense create map and look before inserting in database in this map?
Thanks.
No comments:
Post a Comment