Insert or update, which one is faster/less resource consuming

Tuning and Benchmarks
#1

On a class with 10 properties with an indexed item, which one is less resource (cpu and ram) consuming in a heavy transaction environment; insert new record or update the indexed item of an existing record?

Will this be effected whether class is edge or vertex?

Thank you.

#2

Hi @tolgaulas

There is no difference between normal documents, vertices and edges.
The INSERT is supposed to be a bit faster, just because you do not have to load the old record (ie. access to index + read access to cluster + possible cache miss)

I hope it helps

Thanks

Luigi

1 Like