Say, if I have a huge records in external text file (1 GB) , which contain customers credit score. The format will be "peter;400" line by line. These scores are ONLY those that has been updated recently by credit companies.
Then I need read, parse, update records in database. How to get the best performance / practices in pure
JDBC ?
Here is my thinking
1. create two threads, one is to read, parse, another is to update records in DB. The pipe is ArrayBlockingQueue.
2. use preparedStatement.
3. use some batch update.
Anything I have missed ? Any suggestions ?
Thanks.