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