Django ORM optimization story on selecting the least possible

James Bennett February 23, 2019 Reply

Try this:

from django.contrib.postgres.aggregates import StringAgg
from django.db.models import Func

result = Song.objects.filter(
    artist=artist
).aggregate(
    names_hash=Func(
        StringAgg('name', ''), function='md5'
    )
)

Peter Bengtsson February 23, 2019 Reply

That's awesome! I'm not on my computer so I can't test it but it'd be fast.

Peter Bengtsson February 25, 2019 Reply

See UPDATE above.

Paolo Melchiorre February 27, 2019 Reply

Best optimization
I start thinking to suggest this solution before reading the "Update" section.

P.S. They added "MD5" database function in Django dev:
https://docs.djangoproject.com/en/dev/ref/models/database-functions/#md5