Reread the GAE Query documentation.
Your use case is not the use case that GAE is optimized for.
Fetch fewer records per call.
Example:'=
web2pyChildTableClass = db.ChildTable # gives the web2py Table class
theNativeGAEChildTableClass = web2pyChildTableClass._tableobj # magic...
into native GAE
Hello,
i have the same problem with sqlite/mysql.. when i fetch some 1000 row,
with one column only, its takes about 15/20 seconds to load a page..
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
-
More info again, still hoping someone can help:
I tried to replace the DAL query with native app engine code.
Original DAL:
query=(
(mydb[record].application == application_id) &
(mydb[record].entity == entity_id) &
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) &
4 matches
Mail list logo