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 ?
Thanks in advance
f.g.
— Frédéric Goudal Ingénieur Système, DSI Bordeaux-INP +33 556 84 23 11
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.
Hello,
Yes I should, but if the work had been already done, I did not see any reason to do it again :) But thanks for the last sentence. That’s what I have always done, but I’m trying a new python api that just set the whole value, so I have to rewrite some bits.
f.g.
Le 20 déc. 2023 à 17:29, Howard Chu hyc@symas.com a écrit :
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.
-- -- Howard Chu CTO, Symas Corp. http://www.symas.com Director, Highland Sun http://highlandsun.com/hyc/ Chief Architect, OpenLDAP http://www.openldap.org/project/
— Frédéric Goudal Ingénieur Système, DSI Bordeaux-INP +33 556 84 23 11
openldap-technical@openldap.org