What is more efficient on relational DB (for ex., postgre): join(..) or group_by_val(..)
rows = db(db.person).select().join(db.thing.owner, name="owns", fields=[ db.thing.id, db.thing.name]) vs rows = db(db.person).select( db.person.All, db.thing.id, db.thing.name, join=[ ..on.db.thing.owner=...,) ).group_by_val( db.person.id ) # 1 db request, but more duplicating info in fetched rows ps.: maybe join(..) could be named "join_grouped" for less confusion with select's arg "join" (and better hint what it does) -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.