I have an
inventory table which contains
item_id and the
quantity remaining of the item (And also some other meta data). I have an administrator update the inventory by uploading a CSV file which contains the
item_id and the quantity remaining.
- Run `update for each row in the CSV file. If my CSV file contains 1 million rows, I will end up sending 1 million update statements from my application server to the database server.
- Construct 1 million update queries and send them in a batch (JDBC allows batched statements)
At first glance approach number 2 looks like a better solution. But then can 1 million statements be batched? What happens if one of the statement fails for some reason?