aboutsummaryrefslogtreecommitdiffstats
path: root/pydis_site
diff options
context:
space:
mode:
authorGravatar shtlrs <[email protected]>2023-12-15 10:40:06 +0100
committerGravatar shtlrs <[email protected]>2023-12-15 10:40:06 +0100
commit6eb5f96c14fbb397900ca48736f76e377cebe302 (patch)
treef9eb5d2fd03921dbc4697e87096556e857312468 /pydis_site
parentMerge pull request #1179 from python-discord/dependabot/pip/psycopg-3.1.15 (diff)
insert deleted messages as a Batch
Sentry is sending an N+1 query alert because of the way we were inserting messages (one by one)
Diffstat (limited to 'pydis_site')
-rw-r--r--pydis_site/apps/api/serializers.py9
1 files changed, 3 insertions, 6 deletions
diff --git a/pydis_site/apps/api/serializers.py b/pydis_site/apps/api/serializers.py
index 87fd6190..d7cdfd7e 100644
--- a/pydis_site/apps/api/serializers.py
+++ b/pydis_site/apps/api/serializers.py
@@ -151,12 +151,9 @@ class MessageDeletionContextSerializer(ModelSerializer):
"""
messages = validated_data.pop('deletedmessage_set')
deletion_context = MessageDeletionContext.objects.create(**validated_data)
- for message in messages:
- DeletedMessage.objects.create(
- deletion_context=deletion_context,
- **message
- )
-
+ DeletedMessage.objects.bulk_create(
+ DeletedMessage(deletion_context=deletion_context, **message) for message in messages
+ )
return deletion_context