News for hackers. Stuff that matters.
Re:MongoDB's lead developer: Foursquare outage post mortem by carbocation on Thursday October 07, 2010 @07:36PM (#1769970)
It also depends on your algorithms. Some algorithms are amenable to "running tallies," so a third possible approach would be to store and update various values based only on the aggregate past data plus the incremental data, instead of looking back through the entire history and recomputing when a new piece of data comes in. This of course depends on whether or not this is even theoretically possible with what you're computing.
Re:MongoDB's lead developer: Foursquare outage post mortem by jorgeortiz85 on Thursday October 07, 2010 @08:59PM (#1770174)
This is probably feasible for some badges, but would be hard to do for all of them.

This approach also increases the complexity of adding new badges, which is undesirable for product and business reasons.

It could certainly help in some case though, and it's something we're considering.