Sorry for commenting on my own issue, but i have more information: The following query takes 20 seconds for only 800 items:
query=( (mydb[record].application == application_id) & (mydb[record].entity == entity_id) & (mydb[record].is_deleted == False)) result = db(query).select() I don't think this is normal. I really would like to know what web2py might be really doing in terms of raw GAE query, but unfortunately _lastsql still does not give any info. Any idea / insight would be greatly appreciated! The index seems to exist and serve in GAE Datastore as follows: record application entity is_deleted -- 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.