There are a couple other option too. You could also use some form of materialized views Brett cover in his high throughput data pipelines talk. http://code.google.com/events/io/2010/sessions/high-throughput-data-pipelines-appengine.html
Robert On Thu, Oct 7, 2010 at 12:04, Jeff Schwartz <[email protected]> wrote: > IMO you should maintain a separate set of entities (sharded) for any > aggregate type of information that you wish to maintain. See Google 2009 > YouTube video for info on sharded counters - sorry I don't have the url at > hand but it is easy to find via Google search. > > Also, stay away from count method even though it can now provide results > greater than 1000 - it does not work anything like the one that SQL provides > & is extremely costly. > > Jeff > > On Thu, Oct 7, 2010 at 11:57 AM, nacho <[email protected]> wrote: >> >> Hi, i need to do something like this: >> >> SELECT sum(ammount) FROM purchases >> >> or something like this: >> >> SELECT count(*) FROM sales >> >> But the datastore only let me load 1000 entities, so... is there any >> simple way to do something like that? >> >> For example, one of my clients have more than 10.000 purchases, and he >> wants to know how many sales he haves right now, how can i get that >> number? Or how can i get the sum of the ammount of all purchases? >> >> -- >> You received this message because you are subscribed to the Google Groups >> "Google App Engine" group. >> To post to this group, send email to [email protected]. >> To unsubscribe from this group, send email to >> [email protected]. >> For more options, visit this group at >> http://groups.google.com/group/google-appengine?hl=en. >> > > > > -- > Jeff > > -- > You received this message because you are subscribed to the Google Groups > "Google App Engine" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-appengine?hl=en. > -- You received this message because you are subscribed to the Google Groups "Google App Engine" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
