Sir Xsarus wrote:
It'd be cool to have a graph of posting rate.
you mean (posts/days)/time ?
If so, I don't store that anywhere (i.e. I can't). I also have a feeling the query to do it on the fly would be very expensive.
Yeah, that's what I mean. I'd imagine doing it daily would be expensive, but if you did it quarterly, I'd think that would be doable.
You could just calculate it based on the top 250 list. You could even just use an average of posts/day for every week (or maybe 3-4 days), to keep it more stable, instead of bouncing up and down, which would simply require calculating (postcount-postcountfrom1weekago)/7, for 250 people once a week.
It's not stored, so he'd generate it when you went to the page. Top 250 posters isn't terribly relevant, as you'd have to click the link to activate it anyway.
Another way to do it is just do a transform on the posting graph which implicitly has the info. First derivative! Edited, Jul 28th 2010 11:35am by Xsarus