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

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? Thank you.

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

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

Thank you guys. You know, sometimes it is just easier to delete everything and recreate it once gain, from the algorithmic point of view. But if it is better (yes I have foreign keys and unique keys) to update things than i will make an extra effort to do it properly.

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

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

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

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] Firebird 2.5 Language Reference

Hi, Translation was completed several weeks ago, now Helen Borrie performs proof-reading and editing of the text. Recent preview version of LR looks very promising. Regards, Alexey Kovyazin IBSurgeon Hello everybody Do you know what has happened with the translation of the document

[firebird-support] Firebird 2.5 Language Reference

Hello everybody Do you know what has happened with the translation of the document "Firebird 2.5 Language Reference" from Russian to English? They had requested for donation with the promise that their work would be ready in February 2015. The donation was made, now it is September 2015, but

Re: [firebird-support] Firebird 2.5 Language Reference

Hi, Translation was completed several weeks ago, now Helen Borrie performs proof-reading and editing of the text. Recent preview version of LR looks very promising. Regards, Alexey Kovyazin IBSurgeon Hello everybody Do you know what has happened with the translation of the document

Re: [firebird-support] Firebird 2.5 Language Reference

Thank you very much, Alexey Is there an estimated date for the publication? Greetings. Walter. On Wed, Sep 16, 2015 at 2:34 PM, Alexey Kovyazin a...@ib-aid.com [firebird-support] wrote: > > > Hi, > > Translation was completed several weeks ago, now Helen

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?

Nothing to think of. If you need update go with update otherwise delete and insert is better. Trust yourself. Regards Bogdan --- Original message --- From: 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support] Date: 16. september 2015 5.40.22 pop.

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