On 18 mrt, 10:12, bruno desthuilliers <bruno.desthuilli...@gmail.com> wrote: > On Mar 18, 8:42 am, koenb <koen.bierm...@werk.belgie.be> wrote: > > > Take a look at something like django-selectreverse [1] for inspiration > > on how to reduce your querycount for M2M relations. > > > Koen > > > [1]http://code.google.com/p/django-selectreverse/ > > I must be missing the point, but it looks seriously like reinventing > the wheel ? How is it better than using select_related ???
Select_related only populates forward one-to-many relationships (foreignkeys). It does not work for many-to-many relationships or reverse one-to-many relationships (the XX_set descriptors on the other side of fk's). You can not load those in one and the same query, but you can load all those objects in one single query instead of N extra queries. That is what selectreverse helps you to do. Look at the example on the introduction page of the project to see what kind of queries I mean. Koen -- You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-us...@googlegroups.com. To unsubscribe from this group, send email to django-users+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/django-users?hl=en.
