Re: CallsOnline too big to clean up!

Dale E. Reed Jr. ( (no email) )
Fri, 11 Apr 1997 01:32:52 -0700

Will LaSala wrote:
>
> OK I found out how many I have (74627)
> Now what?

Delete them incrementally. That probably means that you have
that many stop records as well. Use this:

Delete From Calls
Where CallDate < '11/1/96'
And AccStatusType = 1

Execute it, and then up it a month, and repeat through the current
month.
Then runs the charges and it should be much faster. :)

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