[web2py] Re: GAE Datastore performance / potential index issue

2017-05-04 Thread dlypka
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

Re: [web2py] Re: GAE Datastore performance / potential index issue

2017-04-24 Thread Áureo Dias Neto
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) -

[web2py] Re: GAE Datastore performance / potential index issue

2017-04-24 Thread Karoly Kantor
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) &

[web2py] Re: GAE Datastore performance / potential index issue

2017-04-24 Thread Karoly Kantor
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) &