1) Increase the size of your master device and then increase the size of your
tempdb database accordingly. I think it starts at 2mb and I currently have
my cranked to a whopping 12mb. I think I'm going to jump mine up to about
50mb or more but I've only run out of tempdb space once or twice since I've
increased it to 12mb.
2) Put the tempdb in RAM. This is DANGEROUS if you specify the size
of the tempdb to be more than available RAM. Read your docs, caveat
emptor and all that stuff. This is done with the server configuration
options (right click on the server and click configure. It's toward
the bottom. The value of 0 means use the hard drive, anything bigger
means to use RAM.
---> Dale, is the SMALL problem of deleting a sub-account and having it
wipe out VERY important data for companies that bill by the hour and have
to keep these records for x years fixed on 2.1.11? Or do we wait for 2.2
for that also?
Tom
At 04:52 PM 6/20/97 -0400, you wrote:
>----------
>> From: Dale E. Reed Jr. <daler@iea.com>
>> To: emerald@emerald.iea.com
>> Subject: Re: Repost : Calls consolidation problem.
>> Date: Friday, June 20, 1997 1:40 PM
>>
>> Carmine Inteso wrote:
>> >
>> > No problem, this is what I thought it was supposed to do,
>> > BUT What it did not do was update my callshistory table,
>> > Not a single entry.
>>
>> Actually, it probably did. There is a bug in 2.1.8 that is you
>> delete a subaccount, it will delete all entries in your call
>> history, not just the ones associated to the user.
>>
>I didn't delete any subaccounts. Did you see the error message I pasted in
>about running out of tempdb space? Should I upgrade to 2.1.11?
>
>> > What did I do wrong besides waiting 4 months before consolidating?
>>
>> How many entries (or what is the size) of your calls table now?
>>
>6589 rows. I have about 350 - 400 calls per day according to TSGraph.
>
>> > Also have you received my mail about the Cardsoft Services AVS fields?
>>
>> Yes, and I did reply to it. We only have a couple of customers using
>> that, and none use AVS. I'll check into it and see what I can come
>> up with.
>>
>I got your reply. Thanks, I thought the field data was lost in cyber limbo.
> Also,
>do the other customers know if they are paying an additional "discount
>point"
>to Card Services for not using AVS? ( ie. 4.5% instead of 3.5%) We are
>getting charged this fee if we don't use AVS.
>
>Thanks for all the work on everything Dale, I know I'm not the only one
>who appreciates it.
>
>
>Carmine
>Ameri-com Internet Technologies
>"Bringing You the World"
> www.ameri-com.com
>
> ----------------------------------------------------------
> Emerald Mailing List listserver@emerald.iea.com
>
>