Subject Re: [firebird-support] Performance diff between and for select ... do?
Author Mark Rotteveel
On 13-2-2015 14:55, Kjell Rilbe kjell.rilbe@...
[firebird-support] wrote:
> I'm writing a utility that will need to do two things for each record in
> an external table and for this purpose I use a for select ... do
> construct in an execute block. I do it this way because external tables
> can't be indexed and I will scan the entire external table anyway.
> The two operations are:
> 1. Update one existing record in the target table.
> 2. Insert new record in the same target table.

Maybe you can use MERGE, it uses a source, a target and can
conditionally insert, update (and delete) record? I assume your target
table isn't external and is indexed.


Mark Rotteveel