RE: BillMax questions -- Slow Account Load Issues/Removing Closed Services

["Paul Krensky" <paul@nativehosting.com>]

Chris/Ted thanks for the info, probably need to do both (prune closed services and upgrade hardware).

Question, to permanently remove a closed service from an account what is the recommended method?

Thanks,

Paul

Native Hosting, Inc.



-----Original Message-----
From: "Internet Partners, Inc. Tech Support" <support@ipinc.net>
Sent: Fri, June 29, 2007 11:31 am
To: Paul Krensky <paul@nativehosting.com>, questions@billmax.com
Subject: RE: BillMax questions -- Slow Account Load Issues


You can try playing with the mysql settings, (ie: my.conf I think) there's
websites that are devoted to tuning mysql for best performance.

But, in the last analysis, nothing speeds up a database like big
expensive fast disks, lots of memory, and a fast CPU

We are running a dual 500Mhz Xeon with 500MB of ram right now and a raid
array.  But,
we do not take call accounting records so our datacall table is empty.

We previously had a 200Mhz uniprocessor Pentium Pro with 256Mb of
ram.

When I moved the billmax server, reports that took an hour took a
few minutes to run.

Ted

>-----Original Message-----
>From: owner-questions@billmax.com [mailto:owner-questions@billmax.com]On
>Behalf Of Paul Krensky
>Sent: Thursday, June 28, 2007 2:52 PM
>To: questions@billmax.com
>Subject: BillMax questions -- Slow Account Load Issues
>
>
>
>Good day List,
>
>Wondering if anyone else has seen performance issues (very slow 
>loads) for accounts with a longer list of services (300 or so open 
>plus half as many closed). The time it takes to load seems to be 
>increasing as the list of services increases. 
>
>Loading the main account page and trans void pages are taking 
>close to a minute now to load. Main user (which has most of the 
>services) interestingly doesn't take a long time to load (few seconds). 
>
>Other accounts with less services and all reports load quickly.
>
>Any suggestions on how to eliminate or at least reduce this 
>problem would be appreciated. 
>
>Thanks,
>
>Paul
>
>Native Hosting, Inc.
>
>-------------------------------------------------------------------
>----------
>To unsubscribe from the "BillMax Questions" mailing list, please
>send a message to "majordomo@billmax.com" with "unsubscribe questions"
>in the message body. The message must be sent from the exact email
>address on the list.
>


-----------------------------------------------------------------------------
To unsubscribe from the "BillMax Questions" mailing list, please
send a message to "majordomo@billmax.com" with "unsubscribe questions"
in the message body. The message must be sent from the exact email
address on the list.