Thanks for all replies. I think I understand this much better now. It's great to see an active and helpful user group for web2py, I expect I'll be back in here before too long :-)
On Mar 19, 12:45 am, howesc <how...@umich.edu> wrote: > Richard, > > if your query only orders or filters on a single property no index is > required (GAE actually does build an index, but those are auto-generated and > do not need to be specified in your index.yaml). > > some queries that need indexes (assume for a moment that the proper tables > are defined): > > db((db.building.type='house') & (db.building.built > '2010-01-27')).select() > db(db.building.type='house').select(orderby=~db.building.built) > > glad you are enjoying web2py! > > christian
