hypercubed wrote: > I have a table that contains a primary key and two foreign keys (i.e. > id, A_id, B_id, all integers) as well as other data (this is not a join > table). My data design is such that the combination A_id and B_id must > be unique. I'm considering two ways of doing this: > > 1) Before save query the DB and find the primary key (id) for a record > that has A_id and B_id. If that record exists set the id field in my > $data and then Model->save(). This will overwrite the old record if it > exists and create a new one if it doesn't. > > 2) Change id from an auto increment id to a text field. Always set the > id to be the composite (A_id . '/' . B_id). This will also overwrite > the old record if it exists and create a new one if it doesn't. > > Any suggestions on which one I should implement or is there another > option?
I'm curious as to why method 1seems to be less optimal. It does require an extra column in the table, but, unless you have a truly huge number of rows, how much waste could that cause? Probably I am missing something. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" 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 -~----------~----~----~----~------~----~------~--~---
