MySQL Forums
Forum List  »  Newbie

Re: Moving average
Posted by: Peter Brawley
Date: October 30, 2013 10:06AM

There are three basic approaches to running sums & averages---user variables, self-joins, and app-level logic. User vars have their limitations. Self-join approaches bog down with big tables. Both need more normalisation than your tables manifest. So given what you have, I would think app-level logic is caled for.

Options: ReplyQuote


Subject
Written By
Posted
October 29, 2013 08:56AM
October 29, 2013 11:51AM
October 30, 2013 02:40AM
Re: Moving average
October 30, 2013 10:06AM
October 30, 2013 10:24AM
October 30, 2013 01:10PM
November 02, 2013 04:15PM
November 03, 2013 04:18AM
November 03, 2013 10:36PM
November 04, 2013 04:53AM
November 04, 2013 10:52PM
November 05, 2013 02:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.