Each of them has pros and cons. list:(string,integer,reference) are the only option on GAE which does not support joins and web2py provide a compatibility layer on RDBS.
list:... can be used as a way to normalize the database for speed. Good is you need the items in the list for every record, but not good if you need to search records by an element in the list (does not scale). You can use both at the same time to optimize different parts of your code. On Sep 21, 10:17 am, Dalen Kruse <[email protected]> wrote: > I just started out using web2py and I'm really liking it. After > reading the DAL chapter in the book, I'd like to get people's opinion > on something. If I'm using a relational DB (not GAE), is there an > advantage/disadvantage to specifying a relation between tables using a > 'list:integer' field over a traditional relation using joins? > > Thanks, > Dalen
