Why manual delete/insert better than update?
Posted: Sun Sep 25, 2016 12:00 pm
I was trying to understand why manual delete/insert take lesser time than update.
My understanding is this-
Delete/Insert:
Deletes all records from all projections satisfying the predicate condition ( projections in ROS containers are intact /not dropped)
Inserts records into new positions into all projections (containers intact/not dropped)
Update
Deletes all records from all projections satisfying the predicate condition ( projections in ROS containers are intact /not dropped)
Inserts records into same position as the deleted records (since this cant happen , these ROS containers are
dropped , and (existing unchanged records + new records) is reloaded into the new container
Is my understanding correct ?
My understanding is this-
Delete/Insert:
Deletes all records from all projections satisfying the predicate condition ( projections in ROS containers are intact /not dropped)
Inserts records into new positions into all projections (containers intact/not dropped)
Update
Deletes all records from all projections satisfying the predicate condition ( projections in ROS containers are intact /not dropped)
Inserts records into same position as the deleted records (since this cant happen , these ROS containers are
dropped , and (existing unchanged records + new records) is reloaded into the new container
Is my understanding correct ?