http://simonwillison.net/2009-11-23T16:19:52+00:00Simon Willison2009-11-23T16:19:52+00:002009-11-23T16:19:52+00:00https://simonwillison.net/2009/Nov/23/batchselect/#atom-tag

<p><strong><a href="http://github.com/lilspikey/django-batch-select">django-batch-select</a></strong></p> 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. <code>Entry.objects.all()[:10].batch_select("tags")</code> 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. <p><small></small>Via <a href="http://www.psychicorigami.com/2009/11/23/django-batch-select/">Psychic Origami</a></small></p> <p>Tags: <a href="https://simonwillison.net/tags/batchselect">batchselect</a>, <a href="https://simonwillison.net/tags/django">django</a>, <a href="https://simonwillison.net/tags/john-montgomery">john-montgomery</a>, <a href="https://simonwillison.net/tags/manytomany">manytomany</a>, <a href="https://simonwillison.net/tags/orm">orm</a>, <a href="https://simonwillison.net/tags/python">python</a>, <a href="https://simonwillison.net/tags/selectrelated">selectrelated</a>, <a href="https://simonwillison.net/tags/sql">sql</a></p>