Benchmark Networking, Inc.
[mailto:email@example.com] On Behalf Of Michael Whisenant
Sent: Tuesday, June 16, 1998 7:05 AM
Subject: Re: Database Size.
First and foremost you need to perform a calls consolidation, successfully.
The other thing would be to run a checkdb on the Emerald db after deletion
of the records in the calls consolidation process. I have over 5000MBRs
and 30,000 calls per day and my db is less than 300MB, therefore I store
the majority in RAM. I also delete the start records each evening for the
previous day. This reduces the calls table size immediately in half.
At 07:45 PM 6/14/98 -0700, you wrote:
>We have the same problem..A HUGE DB. What command can we use to delete the
>From: Robert Boyle <firstname.lastname@example.org>
>To: email@example.com <firstname.lastname@example.org>
>Date: Sunday, June 14, 1998 11:22 AM
>Subject: Re: Database Size.
>>At 08:13 AM 6/13/98 -0400, you wrote:
>>> We have about 350 MBRs and appoaching 200Meg in size. I have run the
>>> scripts to delete the call records with little effect. I know there is
>>> something else that needs to be done but don't know. I figure the db
>>> be about 60-70 Meg in size.
>>Those are your calls. We have about 1450 MBRs and one month of calls and
>>database is only 29MB. Is your log file on the same device? If so, think
>>moving it to its own device.
>>> Is there any other maintenance that needs to be done. I have seperated
>>> logs for the emerald db so I know it is not the logs.
>>Also try a:
>>See what errors it lists.
Michael J. Whisenant
AIRnet Internet Services, Inc.
ph: (256) 704-4692 fax: (256) 704-2329