Re: Large database but small ISP

Dale E. Reed Jr. ( (no email) )
Thu, 08 May 1997 11:36:46 -0700

James Sandusky wrote:
>
>
> If anyone has some input on the database size and what should be done to keep the size down and everything working smoothly, I would greatly appreciate it. I don't won't to let it fill up and quite authenticating.

If you only have one months worth of data, you probably shouldn't be
using
over 5 or 10 megs of DB space. I would try a DBBC CheckDB(Emerald) or a
DBCC CheckAlloc(Emerald) from ISQL_W and see if you might have some DB
problems. I believe 6.5 also has the OpenTrans option to show you
any option transactions that might be using a large porting of your
datbase.

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