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 --
