Currently reporting data is generated via triggers in the SolarNet database. The triggers run in the same transaction as those committing data (in SolarIn). The triggers are expensive to execute, as they must query and aggregate data to populate into the reporting tables.

The aggregation should be done asynchronously from the SolarIn data input transactions. The aggregation can then be handled in a much more efficient way, and the input transactions will be able to execute much faster. Ideally the aggregation could be handled in batch. For example, a node might post new data every minute, but it might be reasonable to only aggregate reporting data every 5-10 minutes.