Will ,,,=^. .^=,,,
Webmaster
* GreenNet========================================*
* "Link Locally ~ Surf Globally" http://www.greennet.net *
* Come Play On Our Game Server *
* Serving northeastern Massachusetts, southern New Hampshire *
* TEL: 508-363-8898 FAX: 508-363-1225 email:will@greennet.net*
*===============================================*
----------
> From: Dale E. Reed Jr. <daler@iea.com>
> To: emerald@emerald.iea.com
> Subject: Re: CallsOnline too big to clean up!
> Date: Wednesday, April 09, 1997 3:55 PM
>
> Will LaSala wrote:
> >
> > Hi all
> > I have a big problem.
> > My callsonline tables are to huge to run the
> > charges button from Emerald. When I do run
> > it crashes both the server and the client machine I'm using to run
> > Emerald. I removed all the back log up to January in the database
> > but it still is huge and takes for ever to get anyone's online time.
> > What should I do to make that callsonline table smaller?
>
> First make sure you have cleared out all your start records.
> Those are AcctStatusType = 2 records. You can see how many you
> have by doing a:
>
> Select Count(*) From Calls Where AcctStatusType=1
>
> Typically, this will half your calls table. I posted a message
> earlier about having an appropriately sized tempdb database to
> handle the consolidation. Something around 5-15mb should be fine.
> I might add an option to the charges consolidation to allow stepping
> of it, rather than having to do all of it as it currently does.
>
> --
> Dale E. Reed Jr. (daler@iea.com)
> _________________________________________________________________
> IEA Software, Inc. | RadiusNT, Emerald, and NT FAQs
> Internet Solutions for Today | http://www.emerald.iea.com
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com