Re: Manual Call Consolidation via MS Query

Duane Schaub ( )
Mon, 20 Apr 1998 09:27:15 -0500

Be sure that you export your radius file and set radius to use the text
method as the consolidation will cause radius to stop authenticating until
the consolidation is complete. Apparently, its actually just a slow down,
but after a short period, Radius quits running.

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.


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
>> 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
>> 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. (
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today |
> ----------------------------------------------------------
> Emerald Mailing List

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 |
FAX: (316) 332-1451 |