Hey, I think that if you use the containable-behaviour (like I do with all my models...) you can decide everywhere if you want to grab the user- relations or not. So this would not be a problem, and there would be only few actions and sections of the programm that would involve the user-realtions. Like I mentioned before, in this case we discuss here it's not like facebook with 200 million users :)
But the approach with the join table seems right, I'm happy that I know now how to implement such a task. With a group it should be similar, right? If you want to store which user is part of which group, I could use the similar approch with such a table and would know on the user side, in which group the user is a member, and on the group side, which users are members of that group :) It's pretty interesting how things work :) I guess when you code it the right way it should work like a charm with cake! Any others suggestions about thos things? Regards, DD On 29 Aug., 15:46, "Dr. Loboto" <[email protected]> wrote: > As I said, it depends on number of records. And how extensively you > use this table. If almost each user-related query involve this table > much better have straight JOIN condition then OR in it. > > On Aug 29, 4:34 am, Pablo Viojo <[email protected]> wrote: > > > Based on my own experience using medium-sized tables the "or solution" is > > slower than "replicating data solution" > > Just my 2 cents. > > > Regards, > > > Pablo Viojo > > [email protected]http://pviojo.net > > > ¿Que necesitas?http://needish.com > > > On Fri, Aug 28, 2009 at 2:35 AM, Miles J <[email protected]> wrote: > > > > Your calling a few OR queries on a page, its not going to cause any > > > slow performance. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "CakePHP" 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/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
