diff options
| author | daniel a rios <misterrios@gmail.com> | 2019-07-26 15:11:48 +0200 |
|---|---|---|
| committer | Mariusz Felisiak <felisiak.mariusz@gmail.com> | 2019-07-29 09:52:29 +0200 |
| commit | fe33fdc049df75f9dd8e2eecc8c94aefc0132cb8 (patch) | |
| tree | f81c68f8e9c3cbc1ce4e8826a958aab61b006ef2 /docs/topics/db/optimization.txt | |
| parent | 3c6d32e0b233bc44eb4533f81819353036ae35e4 (diff) | |
Refs #30656 -- Reorganized bulk methods in the database optimization docs.
Diffstat (limited to 'docs/topics/db/optimization.txt')
| -rw-r--r-- | docs/topics/db/optimization.txt | 18 |
1 files changed, 14 insertions, 4 deletions
diff --git a/docs/topics/db/optimization.txt b/docs/topics/db/optimization.txt index 671f57a8ae..0f39fae103 100644 --- a/docs/topics/db/optimization.txt +++ b/docs/topics/db/optimization.txt @@ -341,8 +341,13 @@ it on a ``QuerySet`` by calling Adding an index to your database may help to improve ordering performance. -Insert in bulk -============== +Use bulk methods +================ + +Use bulk methods to reduce the number of SQL statements. + +Create in bulk +-------------- When creating objects, where possible, use the :meth:`~django.db.models.query.QuerySet.bulk_create()` method to reduce the @@ -362,8 +367,13 @@ Note that there are a number of :meth:`caveats to this method <django.db.models.query.QuerySet.bulk_create>`, so make sure it's appropriate for your use case. -This also applies to :class:`ManyToManyFields -<django.db.models.ManyToManyField>`, so doing:: +Insert in bulk +-------------- + +When inserting objects into :class:`ManyToManyFields +<django.db.models.ManyToManyField>`, use +:meth:`~django.db.models.fields.related.RelatedManager.add` with multiple +objects to reduce the number of SQL queries. For example:: my_band.members.add(me, my_friend) |
