Re: [Emerald] Serious Issue
Wed, 24 Mar 1999 22:54:14 -0600

On Wed, 24 Mar 1999 20:41:46 -0800, you wrote:

>At 08:06 PM 3/24/99 -0600, you wrote:
>>Well we attempted to consolidate yesterday with no such luck.
>>Our calls table is huge with 1801136
>>records showing on select count(*) from calls
>>The summary shows 13 periods to consolidate. However, about 30 hours
>>only 15k records were done. Is this typical? At that rate we would
>>never finish consolidating. The SQL server runs on a P2-450, 512MB
>Well, you certainly have sufficient hardware. :) While it was =
>is your hard drive light on a lot? Do you have the tempdb set up in =
RAM? With
>this much available memory I'd give it at least 256 meg and give SQL =
Server 384
>meg. I suspect that would speed things up a bit.

Server setup as follows under configure
memory 131072
tempdb in ram 56

>>It seemed to have messed something up after the emerald client was
>>killed...we cannot email invoices out returns an error.
>Did you run a check on the db from ISQL/W?

Didn't run checkdb I think that locks the DB and doesn't allow people
to authenticate and I know it takes quite sometime.

>+ Ben Conner =
>+ Web World, Inc. (714) 639-0595 voice =
>+ PO Box 6548-107 (714) 744-4825 fax =
>+ Orange, Ca 92863 =
>For more information about this list, including removal,
>please see

For more information about this list, including removal,
please see