I'm with you, we have some production tables that use compound keys. The app is like 5 years old! Oh well, if we ever convert this over, there's this small thing called SQL we'll be using ;)
Anyway, it's good to find this out now. On Feb 13, 9:58 am, avairet <[EMAIL PROTECTED]> wrote: > 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 -~----------~----~----~----~------~----~------~--~---