free time

[Jed Gainer]

Why use a different DB?

On Sat, Mar 9, 2013 at 4:28 PM, Fajar A. Nugraha <list at fajar.net> wrote:

> On Sun, Mar 10, 2013 at 8:23 AM, Jed Gainer <jedgainer at gmail.com> wrote:
> > I would still like to be able to see what they use via my admin panel I
> just
> > want FR to ignore it.
>
> Then use different database for it. Something like
>
> if (time isnt between 2am and 5am){
>         sql-for-normal-usage
> }
> else {
>         sql-for-your-admin-panel
> }
>
> As usual, do lots of testing. On first glance, your sql query looks
> fine when you're only dealing with small number of accounting records,
> but would REALLY suck if you have lots of it (say, 10 million records
> in radacct).
>
> --
> Fajar
> -
> List info/subscribe/unsubscribe? See
> http://www.freeradius.org/list/users.html
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.freeradius.org/pipermail/freeradius-users/attachments/20130309/466e9a1c/attachment.html>