Date: Fri, 11 Jun 2004 10:19:42 -0700 From: "Jacob S. Barrett" <jbarrett@amduat.net> To: freebsd-isp@freebsd.org Subject: Re: Bandwidth Usage Billing Message-ID: <200406111019.42631.jbarrett@amduat.net> In-Reply-To: <GMEEINAOJAINFLGLEJNFEEOKCIAA.mitch@bitblock.com> References: <GMEEINAOJAINFLGLEJNFEEOKCIAA.mitch@bitblock.com>
next in thread | previous in thread | raw e-mail | index | archive | help
On Friday 11 June 2004 10:01 am, "Mitch (bitblock)" <mitch@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@amduat.net www.amduat.net "I don't suffer from insanity, I enjoy every minute of it."
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?200406111019.42631.jbarrett>