Subject | What is better: UPDATE or DELETE + INSERT? |
---|---|
Author | |
Post date | 2015-09-16T06:51:11Z |
Hello,
I need to rebuild some records in my database. I have to choices:
1. Firstly I delete set of records and then insert new ones.
2. I update the existing ones.
What solution is preferable? Will scenerio number 1. cause more garbage in database and decrease its performance?
I need to rebuild some records in my database. I have to choices:
1. Firstly I delete set of records and then insert new ones.
2. I update the existing ones.
What solution is preferable? Will scenerio number 1. cause more garbage in database and decrease its performance?
Thank you.