Hi everybody, Today I wanted to add an "avatar" feature to my app, so I created a user profile and put a "get_avatar" method which retrieves the Punbb avatar of the user. Now I'm able to display the users' avatars next to their usernames in their comments, which is nice. What is not nice is that my comments' select_related() method does indeed join the users table (since there's a user related to each comment), avoiding a new query for each comment, but not the user_profile table (since the only relation that exists is the one from user_profile to user, and not from user to user_profile).
So the problem is that one new query is executed for each comment, and my server won't be able to handle ~50 queries on each page (since there's about 50 comments on each page). I was wondering if, when using user profiles, Django couldn't do a LEFT JOIN to fetch the user data AND the user profile in ONE query, avoiding lots and lots of future queries ? Or maybe I missed something ? Thanks for your answers. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Django users" group. To post to this group, send email to django-users@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/django-users?hl=en -~----------~----~----~----~------~----~------~--~---
