[google-appengine] Re: Easy way to agregate query language functions?
i think it is not possible. instead, you can keep a field in basket entity, and update this field in every operation. it may be better according to nosql mentality (i guess so). On 7 Ekim, 18:57, nacho 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 google-appeng...@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
Re: [google-appengine] Re: Easy way to agregate query language functions?
quien me da una cotizacion ? le doy el contenido ? patricio...@gmail.com skype patriciony On Thu, Oct 7, 2010 at 1:45 PM, nacho wrote: > Thaks both, i will see those options. > > On 7 oct, 13:18, Robert Kluin wrote: >> 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-p... >> >> Robert >> >> On Thu, Oct 7, 2010 at 12:04, Jeff Schwartz 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 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 google-appeng...@googlegroups.com. >> >> To unsubscribe from this group, send email to >> >> google-appengine+unsubscr...@googlegroups.com. >> >> 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 google-appeng...@googlegroups.com. >> > To unsubscribe from this group, send email to >> > google-appengine+unsubscr...@googlegroups.com. >> > 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 google-appeng...@googlegroups.com. > To unsubscribe from this group, send email to > google-appengine+unsubscr...@googlegroups.com. > 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 google-appeng...@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.
[google-appengine] Re: Easy way to agregate query language functions?
Thaks both, i will see those options. On 7 oct, 13:18, Robert Kluin wrote: > 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-p... > > Robert > > On Thu, Oct 7, 2010 at 12:04, Jeff Schwartz 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 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 google-appeng...@googlegroups.com. > >> To unsubscribe from this group, send email to > >> google-appengine+unsubscr...@googlegroups.com. > >> 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 google-appeng...@googlegroups.com. > > To unsubscribe from this group, send email to > > google-appengine+unsubscr...@googlegroups.com. > > 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 google-appeng...@googlegroups.com. To unsubscribe from this group, send email to google-appengine+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/google-appengine?hl=en.