Fastest Way to Update a bunch of records in queryset in Django
Actually, that didn't work out for me.
The following did:
Entry.objects.all().update(value=(F('value')==False))
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?