Simon Willison’s Weblog

Subscribe
Atom feed for batchselect

1 item tagged “batchselect”

2009

django-batch-select (via) A smart attempt at solving select_related for many-to-many relationships in Django. Add a custom manager to your model and call e.g. Entry.objects.all()[:10].batch_select(“tags”) to execute two queries—one pulling back the first ten entries and another using an “IN” query against the tags table to pull back all of the tags for those entries in one go.

# 23rd November 2009, 4:19 pm / batchselect, django, john-montgomery, manytomany, orm, python, selectrelated, sql