A
A
Alexander2017-09-22 10:19:10
MySQL
Alexander, 2017-09-22 10:19:10

How in Django (MySQL) you can bulk update records in the database with different values?

There is a table
cf65aab4ae584d0f9e2b99ef63aa6f6d.png
The table is planned to have about 100,000 records.
I need to select all the records, pass them through a number of methods (filter, calculate) and update the remaining ones (80,000 records may remain).
The trick is that when processing the table fields "left_points" and "right_points" - for each record there will be different ones.
Question. How to bulk update records with different values ​​as efficiently as possible?

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question