Re: [firebird-support] Firebird 2.5 Language Reference

2015-09-16 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
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 "Fireb

Re: [firebird-support] Firebird 2.5 Language Reference

2015-09-16 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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 Borrie performs > proof-reading and e

Re: [firebird-support] Firebird 2.5 Language Reference

2015-09-16 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
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 "Firebi

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

2015-09-16 Thread Mordico1 bog...@mordicom.si [firebird-support]
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. Subject: RE: [firebird-support] What

[firebird-support] Firebird 2.5 Language Reference

2015-09-16 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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 wit

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

2015-09-16 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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 > > http://ru.scribd.com/doc/20128182/The-InterBase-and-Firebird-Developer-Magazine-Issue-2-2005 > > Regards, > Alexey K

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

2015-09-16 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
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 -

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

2015-09-16 Thread 'Walter R. Ojeda Valiente' sistemas2000profesio...@gmail.com [firebird-support]
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 better.

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

2015-09-16 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
> 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

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

2015-09-16 Thread hv...@users.sourceforge.net [firebird-support]
> ---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 scenerio number 1. cause mo

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

2015-09-16 Thread brucedickin...@wp.pl [firebird-support]
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?

2015-09-16 Thread Tim Ward t...@telensa.com [firebird-support]
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 gar

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

2015-09-16 Thread 'Martijn Tonies (Upscene Productions)' m.ton...@upscene.com [firebird-support]
>> 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? > >T