Make the user_profile->sfGuardUser a 1:1 relationship, then you don't need to do a join - the profile ID will always be the same as the user id.
Realistically, are users ever going to have more than 1 profile? On 19 May 2008, at 10:34, kayoone wrote: > > nobody using sfGuard for complex projects? Common :) > > I dont see a problem i using the profile_id to link it with site > content, but it would need 2 joins then to get the username. > > eg: > $article->getMemberProfile()->getsfGuardUser()->getUsername() > > That would result in more complex queries, which might be slower > especially when there is a list to be displayed with many entries > and usernames. > > Really wondering how people do it, if you use the sfguarduser table > you have to get the sfguard schema.yml into your main schema and then > you have the problems i described above. > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
