The only reason I can see for allowing references on a field other than id is if you are de-normalizing, i.e. duplicating some data from a reference table into your primary table to save a join. I'm not sure how common this is and I would be tempted to stipulate that the reference was still by id (so have both id and duplicated field in primary table).
Pmate: with respect, how does referencing by id or field affect indices in respect of speed and foreign relationship? (apart from if the non-id is text it will probably be a little slower). > Should we allow references other than to the id field? On Nov 29, 2:34 pm, pmate <[EMAIL PROTECTED]> wrote: > yes Denesi, that's the point. > Usually indexes in a table can be more than one. And they are useful > for the speed of queries and for foreign relationship, i think --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to web2py@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---