views:

89

answers:

1

I have a queryset with a few million records. I need to update a Boolean Value, fundamentally toggle it, so that in the database table the values are reset. What's the fastest way to do that?

I tried traversing the queryset and updating and saving each record, that obviously takes ages? We need to do this very fast, any suggestions?

+3  A: 

See the documentation:

Entry.objects.all().update(value= not F('value'))
Felix Kling
Thanks! I must read the docs better
ramdaz