User Perf

gistfile1.py

        #don't multiply queryset for user.get_profile...
        #coworkers is a queryset of User
         
        coworkers_id = set([c.id for c in coworkers])
        from users_profiles.models import UserProfile
        profiles = UserProfile.objects.filter(user__in=coworkers_id)
        co_profiles = dict((u.id, u) for u in profiles)

        for co in coworkers:
           co.get_profile = co_profiles.get(co.id)
        return coworkers

    coworkers_id = set([c.id for c in coworkers])
    from users_profiles.models import UserProfile
    co_profiles = UserProfile.objects.in_bulk(coworkers_id)

    for co in coworkers:
       co.get_profile = co_profiles.get(co.id)
    return coworkers

Via 'RawQuerySet', however, impossible to chain with "queryset" methods

return coworkers.objects.raw('SELECT * FROM auth_user INNER JOIN users_profiles_userprofile ON (users_profiles_userprofile.user_id = auth_user.id)')