On 15 Sep 2015 23:51:11 -0700, "brucedickinson@... [firebird-support]"
<firebird-support@yahoogroups.com> 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

in

> 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.

Mark