Subject AW: [firebird-support] thoughts on duplicate checking, input needed
Author Alexander Gräf
> -----Ursprüngliche Nachricht-----
> Von: thomas.besand@... [mailto:thomas.besand@...]
> Gesendet: Freitag, 8. April 2005 13:00
> An:
> Betreff: [firebird-support] thoughts on duplicate checking,
> input needed

Hello Thomas,

because the structure of the destination table is clear before the process, you could write a stored procedure and let the database server decide if a new row is inserted or if an existing row should be updated. I think this will be a lot faster than selecting and then inserting/updating for each and every row in the source table. Anyway, firebird is fast enough, i think, so you can go the dirty way and issue the SELECT/INSERT/UPDATE for each row without fearing bad performance.

Regards, Alex