Infrastructure » Websites

Designing a summary table where after each day is finished a record is created in a report table. E.g.

signature_id, count, bugs_ids, first_date, last_date, version_id, date

This way the report does not need to count all crashes everytime but just SELECT the according record by date (version etc) and summarize days when needed, for example query for the last 30 days to show a report for 30 days.

It is assumed that the report is always limited by the last n days to work.