Django Queryset .save() is slow

Asked Oct 03 '18 at 18:39

Active Oct 03 '18 at 18:39

Viewed 315 times

I'm trying to perform some operations over a queryset and then use the .save() on each model instance, but it seems to be slow.

for clock in Clocks.objects.filter(status=True):
     # actions here
     clock.save()

Is this correct or is there any other method to be used when updating a model instance within a queryset.

Do you think DRF can perform this any better?

asked Oct 03 '18 at 18:39

erick.chali

2

Possible duplicate of [How to 'bulk update' with Django](https://stackoverflow.com/questions/12661253/how-to-bulk-update-with-django). – YellowShark Oct 03 '18 at 18:44
Try to do the update on the database, here this will result in *2N* queries, with *N* the number of `Clocks` with `status=True`. – Willem Van Onsem Oct 03 '18 at 18:52
@YellowShark that will update all records with the same value, and that is not what I need :( – erick.chali Oct 03 '18 at 18:55
@WillemVanOnsem yeah I guess that will be the only way, I was just trying to check all posibilities before performing a raw query. – erick.chali Oct 03 '18 at 18:56
1

@erick.chali: if the operation is rather "simple" you can use an SQL expression. – Willem Van Onsem Oct 03 '18 at 18:57

0 Answers0