Subject Re: [firebird-support] What is better: UPDATE or DELETE + INSERT?
Author Mark Rotteveel
On 15 Sep 2015 23:51:11 -0700, "brucedickinson@... [firebird-support]"
<> wrote:
> 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
> database and decrease its performance?

They will generate a comparable amount of garbage, but I think updating
the existing records is better than delete + insert, especially if there
are also foreign key references to those records.