It seems reading data sequentially is the only option and is costly. My entities are already de-normalized to some extent and I cant keep counter to a separate table as reports can have conditions like date range and other parameters.
Now the big question is the cost of sequential search in term of resource uses in app-engine. I am not talking about terabyte of data, lets say about 2 million record in a single entity. Any advice from practical experience to similar scenario is appreciated. I am willing to leave app-engine if it seems too dirty and costly to manage. Thanks Sabbir On Jan 7, 7:07 pm, sabbir <sabbir...@gmail.com> wrote: > Hi All, > > Wondering how to best implement GROUP BY in google app-engine, on > large data set. > > Example Entity: > > >>Transaction (sl, accountsCode, accountsName, amount, status) > > Then what is the best approach to do something like this in app- > engine: > > >> select accountsCode, sum(amount) > > What I can do with brute force is - > - Select All > - Then read each record > - populate a List with sum / count > > But this seems so inefficient, and will require too much extra code. > > Thanks, > sabbir
