Subject Re: [firebird-support] update from select
Author Ann W. Harrison
niegil.thomas@... wrote:
> Hi Sasha,
> I feel better than updating , Do Multiple selects in a
> query and delete the existing record from the table and
> append this query to the table i feel this will be faster .
> Please be carefull to uses all key fields properly.
> I found such a move to faster . Hope this Eg meets ur requirement .

Aside from such problems as inadvertently cascading deletes
through foreign key constraints and triggers, this method also
requires updating all fields, complicating index management
and garbage collection. Did you actually measure the performance
or are you guessing?

Generally, using UPDATE to change records and DELETE to remove
them makes codes easier to write, understand, and maintain.