I need some help to perform a harmonic media calculation of an "infinite" series so to speak. Ex. I have a data capture system that is always injecting information into a DB. But there are many points added every minute and I need to generate a historical media value of all points in the series since its inception ... This generates a lot of processing time for the DB and the PC so every minute is updating this statistic ...
I would like to know if I would have any way to consolidate the media until the last minute and then perform the new average only with this consolidated value and the new potos acquired after consolidation ???
I'm programming in C with BD SQLServer.
Thank you ..