Thread: Best method for large updates

Best method for large updates

From
Francisco Reyes
Date:
When doing large updates which approach is better:

1- Delete all rows which exist and that will be updated. Insert all new
data.

2- Process updates for all existing data, merge new data.