Re: [Emerald] Database Size
Dale E. Reed Jr. ( (no email) )
Mon, 17 May 1999 12:33:29 -0700
Jason Powell wrote:
>
> Jason Powell wrote:
> >
> > I have around 2500 users, and my data size for the Emerald database is
> 1024
> > MB, Data Space Available 182 MB. After I have done a call consolidation,
> > the db actually seemed to grow instead of shrink....I have also ran a
> > checkdb. Is there anything I can do to cut down on the size of the db?
>
> You didn't include what version of Emerald you are using? Emerald 2.5
> does NOT delete any call records. You can go into the Emerald Admin,
> DB Maintence to trim call records.
>
> I am using Version 2.5 of Emerald, and I have trimmed choosing 6 months. Is
> that a standard database size for that, and should I trim all but 2 months?
Someone asked me yesterday how often they needed to trim their calls
table and I responded "thats like me telling you how often you need
to fill your gas tank". Without knowing your users driving habits,
I can only guess. For example, if you have a lot of dial on demand
ISDN, you'll probably see a larger number of call records from someone
that mainly has users that call once a day for 1/2 each.
The number of months to keep is up to you, but it should be atleast
2 months.
--
Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com