Re: [firebird-support] What is better: UPDATE or DELETE + INSERT?

On 15 Sep 2015 23:51:11 -0700, "brucedickin...@wp.pl [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. > >

Re: [firebird-support] What is better: UPDATE or DELETE + INSERT?

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

Re: [firebird-support] What is better: UPDATE or DELETE + INSERT?

On 16/09/2015 07:51, brucedickin...@wp.pl [firebird-support] wrote: 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

RE: [firebird-support] What is better: UPDATE or DELETE + INSERT?

> 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. I don't think so. Unless you are updating every column in the row, the UPDATE will generate a

Re: [firebird-support] What is better: UPDATE or DELETE + INSERT?

Thank you very much, Alexey. Greetings. Walter. On Wed, Sep 16, 2015 at 1:36 PM, Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote: > > > Hi, > > See page 20-21 here > >

RE: [firebird-support] What is better: UPDATE or DELETE + INSERT?

22 pop. Subject: RE: [firebird-support] What is better: UPDATE or DELETE + INSERT? To: firebird-support@yahoogroups.com 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

Re: [firebird-support] What is better: UPDATE or DELETE + INSERT?

Hello Sean, and everybody That's a very interesting and very important theme: "the new record version will only include the updated fields -- not a full copy of the row" Do you know where I can find a document, web-page, book or video that explains that? If it has images or graphics, much

Re: [firebird-support] What is better: UPDATE or DELETE + INSERT?

Hi, See page 20-21 here http://ru.scribd.com/doc/20128182/The-InterBase-and-Firebird-Developer-Magazine-Issue-2-2005 Regards, Alexey Kovyazin IBSurgeon Hello Sean, and everybody That's a very interesting and very important theme: "the new record version will only include the updated fields