Re: RadiusNT and Calls Table

Dale E. Reed Jr. ( (no email) )
Fri, 12 Dec 1997 08:48:11 -0800

Brian Lube wrote:
>
> Another thing that I've noticed is that the calls table tends to get really fragmented on my system. I have a program to calculate usage for my users, and if I don't reindex the calls table about every day it crashes on me. Also, the speed of the processing is slowing down significantly. Any ideas?

Index it for all WHERE criteria and gives it lots of memory. DO NOT create
a clustered index on the table, either.

-- Dale E. Reed Jr.  (daler@iea.com)_________________________________________________________________       IEA Software, Inc.      |  RadiusNT, Emerald, and NT FAQs Internet Solutions for Today  |   http://www.iea-software.com