Re: Insert vs Update

On Wed, Jul 15, 2015 at 3:16 PM, Robert DiFalco <robert(dot)difalco(at)gmail(dot)com>
wrote:

>
> Thanks David, my example was a big simplification, but I appreciate your
> guidance. The different event types have differing amounts of related data.
> Query speed on this schema is not important, it's really the write speed
> that matters. So I was just wondering given the INSERT or UPDATE approach
> (with no indexed data being changed) if one is likely to be substantially
> faster than the other.
>
>
As I understand how ACID compliance is done, updating a record will require
updating any indexes for that record, even if the index keys are not
changing. That's because any pending transactions still need to be able to
find the 'old' data, while new transactions need to be able to find the
'new' data. And ACID also means an update is essentially a
delete-and-insert.
--
Mike Nolan