Best Design for creating Historic Reports on GAE

Posted by charming30 on Stack Overflow See other posts from Stack Overflow or by charming30
Published on 2010-02-23T20:02:50Z Indexed on 2010/05/15 5:04 UTC
Read the original article Hit count: 192

Filed under:

My App requires Daily reports based on various user activities. My current design does not sum the daily totals in database, which means I must compute them everytime.

For example A report that shows Top 100 users based on the number of submissions they have made on a given day.

  1. For such a report If I have 50,000 users, what is the best way to create daily report?
  2. How to create monthly and yearly report with such data?

If this is not a good design, then how to deal with such design decision when the metrics of the report are not clear during db design and by the time it is clear we already have huge data with limited parameters (fields).

Please advice.

© Stack Overflow or respective owner

Related posts about google-app-engine