i made a patch for review....http://code.google.com/p/web2py/issues/detail?id=1143
On Monday, October 15, 2012 7:26:00 PM UTC-7, howesc wrote: > > Hi all, > > I am trying to integrate smartgrid into my web2py GAE app......but i have > some tables with millions of rows, so when i want to load a table with no > query filters the count() fails to return on GAE in 60 seconds. > > I'm thinking about creating a patch to grid/smartgrid that does not use > row count on GAE, and uses cursors for pagination. the drawback is that > you won't be able to see the total count of rows. > > i'm also considering enhancing the count() method for GAE connections to > be able to pass in extra attributes to pass through to the GAE count() > method: > https://developers.google.com/appengine/docs/python/datastore/queryclass#Query_count > namely limit and/or deadline (depending on my use case). i don't really > want count() to take my full 60 second processing time leaving me with no > time to recover.... > > does anyone have thoughts or opinions about grid/smartgrid and how > count/pagination works currently? would there be objections to a DAL patch > that supports extra attributes in the GAE version of count()? > > thanks for the insights! > > christian > --