Bandwidth Usage Billing

[Jacob S. Barrett]

On Friday 11 June 2004 10:01 am, "Mitch (bitblock)" <mitch at bitblock.com> 
wrote:
> I don't use cricket - we rolled our own, but the main advantage I have to
> SQL storage, is that the numbers don't change - when 5 seconds become 20
> minute averages, your monthly numbers often change slightly, which gives
> the "more alert" customers something to ask about ;-)

Yeah, that is why we keep the 5 second data for 3 months.  The default is 
something like 15 days, which obviously won't give you the most accurate 
accounting.  We obviously keep a snap shot of each billing cycle, but we just 
let the data fade away over time.  Until we start having customers come back 
and want a years worth of detailed reporting we probably won't keep the 5 
second data longer than 3 months.  For the picky customers we can easily 
increase it to a year.  Besides, after a month the noticeable difference on 
the 5 second to 20 minute rounding is pretty small, less than a few megs, and 
since we are talking 10+Gs, no one really cares. :)


-- 
Jacob S. Barrett
jbarrett at amduat.net
www.amduat.net

"I don't suffer from insanity, I enjoy every minute of it."