Billf: if you read well my post you see that i never spoke about any affectation. All i meant it was that i didn't see anything strange in creating more indexes in the same table (different from id). And that i didn't see anything strange in creating relationship with these indexes. I said what indexes are for and not that referencing by one field would improve speed better than referencing by an other. Never thought. Never thought neither to set an index other than integer (as in my example). Massimo answered that he didn't provide this functionality because he doesn't consider it a good software engineering practice. That's all
> > 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). > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
