I have asked again my SQL gurus about this "hack" using in Cake. Their answer is : "adding an Id field is possible, but it will result to a sensible performance decrease (I/O bound effect)."
Hope this help to improve Cake capacities for the future releases... Avairet On 13 fév, 14:25, avairet <[EMAIL PROTECTED]> wrote: > Hello! > > I've read this discussion and asked question about it to an older DBA, > master of Modelisation and SQL theory since 30 years. > He says there are a lot of stupidities and many authors need studying > Modelisation and Theory before posting... > Only one thing: a Primary Key is not equal to Unique not null index! > > I'm agree with you : Cake doesn't a whole lot! > But it will better if it respects some basical rules, like compound > PK... isn't it? > > So, temporarily, I will add "a dump auto incrementing ID" to my > relational tables! > > Avairet > > On 12 fév, 18:19, Baz <[EMAIL PROTECTED]> wrote: > > > Here are some interesting discussions: > > >http://groups.google.com/group/cake-php/browse_thread/thread/4a3f44f8...... > > > Bottom line (from what I gather), it was done so to make Cake work easier. > > > I still don't think a lot of people appreciate the fact that Cake does a > > whole lot! So hey, if I need to add a dump auto incrementing ID, that's what > > I'm gonna do. > > > On Feb 12, 2008 10:48 AM, avairet <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > I've the same question. > > > Cake will never support compound or multiple primary keys?? Why? > > > How manage this issue? > > > > Thanks by advance > > > > Avairet > > > > On 12 fév, 09:44, "Matias Lespiau" <[EMAIL PROTECTED]> wrote: > > > > On Feb 12, 2008 3:56 AM, adammc84 <[EMAIL PROTECTED]> wrote: > > > > > > if the MySql database table my model is 'modeled' from has a primary > > > > > key that is user_id,posts_id how do i configure that in cake model to > > > > > use a dual primary key ? > > > > > Hi adammc84, > > > > > Cake does not support multiple primary keys. > > > > > -- > > > > Matias Lespiauhttp://www.gignus.com/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to cake-php@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---