Efficient method to update one field with diferent values in a django model

Question

I have many pk-value in a dictionary and I want to update the object with his new value.

to_update = [{'id':id1,'value':value1}, ... ]

Now i'm doing this:

for t in to_update:
    Mymodel.objects.filter(pk=t['id']).update(myfield=t['value'])

I think thant i can do this in a better way, but i didn't find it. Thank You

Answer 1

This is the most efficient way. QuerySet.update() is converted directly to an UPDATE statement, and there is no more efficient way of doing it than that.