Re: [RadiusNT] Calls Performance

Tom Pipes ( )
Tue, 10 Oct 2000 09:02:51 -0500

Deletes, selects, everything.

Select Username, AcctsessionID, NASIdentifier from calls where
username='xxx' and calldate > 'x/x/x xx:xx'


delete from calls where calldate > 'x/x/x xx:xx'

I have a lot of holes in the calls accounting.

Tom Pipes
Essex Computers

At 03:01 PM 10/6/00 -0700, you wrote:
>Tom Pipes wrote:
>> 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).
>Terrible response time doing what? Inserting, updating, deleting?
>What query are you running? One query on a table can take 4ms,
>whereas a similar wone can take 4 hours. Without really understanding
>what you are doing (and with what DB), its tough for someone to
>give you advise.
>Dale E. Reed Jr. Emerald and RadiusNT/X
>IEA Software, Inc.
>For more information about this list (including removal) go to:

For more information about this list (including removal) go to: