Instead of spoon-feeding you, I would recommend using DDT and check out the query that is generated and whether if it satisfies your use-case. By this, you will know how exactly select_related works and also the number of queries that gets fired in the page and what happens once you use this.
On Thu, May 1, 2014 at 6:52 PM, Andreas Bloch <[email protected]> wrote: > Okay, I'm a little confused here about using select_ralated... > > Can you only run select_related on a table that HAS a foreign key not a > table that IS a foreign key? > > What if I want to go: > SELECT * FROM product LEFT JOIN review on product.id = review.product_id > LEFT JOIN comments ON product.id = comment.product_id > > example models.py > > class Product(models.Model): > name = > > class Review(models.Model): > product = models.Foreignkey(Product) > rating = > > class Comments(models.Model): > product = models.Foreignkey(Product) > text = > > In my templates I want to be able to loop through all reviews and comments > for each product without hitting the database multiple times... > > How can you achieve this? > > > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to [email protected]. > Visit this group at http://groups.google.com/group/django-users. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/5370daf6-58d0-4573-a282-36c4a70a5937%40googlegroups.com<https://groups.google.com/d/msgid/django-users/5370daf6-58d0-4573-a282-36c4a70a5937%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/django-users. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAN7tdFSqW4cmAdrKsCNqP%3D9BwRrxfF8XNx51_2yKFuqNw7KtsA%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
