Waht is better: Insert and update or Select Update else insert

Hi,

what is the better (performance) if I want to make many updates and inserts:

1. INSERT and if fails then update or
2. Select for Update and if records found update else insert

The second is better in my opinion, because if I using also the nowait clause I get a checked whether the record is also be locked.

But what is better in performance on condition that insert and updates has nearly the same quantity.

Thanks in advance

regards
Nicolas Received on Sun Nov 05 2000 - 08:52:16 CST