Re: Most efficient way to update multivalued attributes

Frédéric Goudal wrote:

Hello,

I have to update records with mutlivalued attributes, and I wonder what is the best (fastest, or lighter for the server) to do :

• either just set the value with the new list

• or calculate which values to add and which to delete and than do the add and remove operations.

And to be a bit more precise, if we have a big number of values is one of the two way best ?

You should profile it yourself and see.

Generally, you should only change what needs to be changed, so setting the entire value to a new list is the worst choice.