Fastest Way to Update a bunch of records in queryset in Django
database, django, django-queryset, python
Solution
See the documentation:
Entry.objects.all().update(value= not F('value'))
Problem
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?