Go into Enterprise Manager, Edit your Emerald Database, and on the
options tabs, you can enable "No Checkpoint on recovery" and "Truncate
Log on Checkpoint". This should keep your database logs to a minimum.
Additionally, run the checkdb.sql script against your Emerald database
about once a week and it will keep everything inorder and correct
any allocation issues.
> -----Original Message-----
> From: Dale E. Reed Jr. <daler@iea-software.com>
> To: emerald@emerald.iea.com <emerald@emerald.iea.com>
> Date: Saturday, March 07, 1998 10:31 PM
> Subject: Re: Need Quick script for deleting calls records!
>
> >Tom Bilan wrote:
> >>
> >> delete from calls where acctstatustype = 1
> >
> >As a side note, if you are doing this often (I have SQL Executive
> >do it every night), you should put an index on the acctstatustype
> >field in the calls table. It will greatly improve the speed. :)
> >
> >--
> >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
> >
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
-- 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