Hi, Thank you for the quick feedback. It seems that the suggested model would easily provide a *total* count. However, I need to compute periodic totals based on the last X votes. How would I update the count for each link considering only the votes submitted in the last hour?
I am currently reviewing my model. However I am still very interested in receiving feedback from the community on this issue. -- Sérgio Nunes On Feb 23, 4:45 pm, Brandon Thomson <[email protected]> wrote: > Hi Sergio, > > How about this: > > class item(db.Model): > numVotes = db.IntegerProperty() > url = db.LinkProperty() > timestamp = db.DateTimeProperty(auto_now_add=True) > > You may need to shard the items if you expect more than 5 votes per > item per second. > > On Feb 22, 8:59 pm, Sérgio Nunes <[email protected]> wrote: > > > Hi, > > > I would like to have the community's advice about the best way to > > implement a group + count feature. > > Imagine a Digg-like application with a simple model to store user > > votes (many details discarded for simplicity): > > > class vote(db.Model): > > url = db.LinkProperty() > > timestamp = db.DateTimeProperty(auto_now_add=True) > > > So, how would you compute a simple query like: ordered list of URLs > > with most votes in the last hour. > > As you might note, this is not a "global counter" since it depends on > > a "filter". > > > How should this be implemented? It the underlying model flawed? > > Or is this simply a problem for which GAE is not the best option? > > > Thanks in advance for your comments, > > -- > > Sérgio Nunes --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
