On 15 Sep 2015 23:51:11 -0700, "[email protected] [firebird-support]" <[email protected]> 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
