in reply to Re: std dev calculations slow over time
in thread std dev calculations slow over time

Nice++.

How refreshing to see some working DB code posted and benchmarked rather than just alluded to.

As for the scaling, the pure perl only wins whilst the dataset will fit in memory...then your DB appproach wins hands down without resorting to messy overlapping reads :)

Examine what is said, not who speaks -- Silence betokens consent -- Love the truth but pardon error.
Lingua non convalesco, consenesco et abolesco. -- Rule 1 has a caveat! -- Who broke the cabal?
"Science is about questioning the status quo. Questioning authority".
In the absence of evidence, opinion is indistinguishable from prejudice.
  • Comment on Re^2: std dev calculations slow over time

In Section Seekers of Perl Wisdom