[RadiusNT] Re: RadiusNT Digest
Edsonet ( email@example.com )
Sat, 07 Oct 2000 08:37:08 -0600
At 12:00 AM 10/07/2000 -0700, you wrote:
>Subject: [RadiusNT] Calls Performance
>From: Tom Pipes <firstname.lastname@example.org>
>Date: Fri, 06 Oct 2000 16:43:04 -0500
>My calls table has a terrible response time. All other tables perform
>excellent. Even when I stop my radius service the calls performance is
>unsatisfactory. I need to purge the calls occasionally, but it is
>difficult to keep up with when it takes so long. I reindexed on the
>"calldate", but it did not seem to make a difference (with the thought that
>my index was possibly a problem).
>Any ideas? Should I re-create the calls database over again, or is there
>something else I can do?
**************** REPLY SEAPRATER ******************
We run our own accounting program, and part of the program is to save the
call data in a separate database. Periodically, the program runs a query on
the Calls table for anything older than 24 hours, transfers it to the new
database, and then deletes it from the Radius database. That way, the
Radius database only has the last 24 hours of call info and is kept small
and responsive. When we have finsihed with the Call info in the new
database, it is archived and we start all over again.
For more information about this list (including removal) go to: