Обсуждение: Best method for large updates

Поиск
Список
Период
Сортировка

Best method for large updates

От
Francisco Reyes
Дата:
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.