My machine used to take about 3 hours to run consolidation per week of
calls. (P166 with 64MB ram). I upped the RAM to 96 and set the Temp table
to be 20MB of RAM and set radius to only store stop records and now it
takes 15 Minutes per week.
Duane.
At 09:33 PM 4/19/98 -0700, you wrote:
>Rudy Komsic wrote:
>>
>> I was wondering if someone can give me the proper SQL commands to
consolidate
>> call Information so that I would be able to reduce our database. Currently
>> our database is about 500 MB with Time information dating back about 5
months
>> now.
>
>Its NOT an SQL statement. Its a very complex set of codes that
>manipulates the data in the database. You can run the call
>consolidation from Emerald.
>
>--
>Dale E. Reed Jr. (daler@iea-software.com)
>_________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.iea-software.com
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
==========================================================================
Duane Schaub, President |Terra World, Inc - Connecting The Planet
Terra World, Inc. |Southeast Kansas' Leading Provider
200 Arco Place, Suite 252 |Flat Fee - Never an hourly Charge
Independence, Kansas 67301 |Where Service is Top Priority!
Voice (316) 332-1616 |http://www.terraworld.net
FAX: (316) 332-1451 |dschaub@terraworld.net
===========================================================================