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 [email protected].
For more options, visit https://groups.google.com/d/optout.
