We have a CSV the user imports into the Application.
After inspecting the CSV, validating and applying some business logic, we got Inserts and Updates operations we should perform into a table(Subscribers)
We got around 1 millions of inserts and 1 million of updates operations.
Which will be the most effective way to execute them?
1) For the inserts we planned to put them in a CSV file and execute them as a BULK INSERT.
2) What should we do for the updates? Is there something similar to BULK INSERT?
3) Is there any other optimization we should look?
3a) Like for example disabling the indexes while doing this? We should consider the DB should be kept available as normal for the other users of the application...
3b) Suggestions ????