The speed of the billing stuff is a function of how many data points are in the database, which is related to how many bills you have, and how long it's been running.
If you're getting issues so quickly, you're probably tracking a *lot* of bills.
Sounds like you need a bigger database server, with lots of RAM.
Don't forget that you're basically putting an entry into the database every 5 minutes for every bill, and when you generate a bill you're sorting that entire table.
It's possible there are some optimisations that can be done to the billing code and/or database, too. Perhaps table-per-bill would be quicker.
adam.
On Thu, 20 Oct 2011 17:56:42 +0100, Mahomed Hussein Mahomed@CustodianDC.com wrote:
Hi
Is anyone using 95th billing in observium? I've been having slowness issues with it, so I setup a new server, downloaded the latest version
and
cleared all the billing tables and let it start polling again. This was fine and the polling has been working. The page was loading in less than
a
second. As the days have gone on, the bills page has been getting slower and slower and now takes at least 20 seconds to load.
I am just wondering if this is normal or if there is something wrong. Thanks.
Kind regards,
Mahomed Hussein
Senior Operations Engineer
[cid:image936b14.jpg@74cffa9e.a72241e4]http://www.custodiandc.com/
Tel:
+44 (0)1622 230 382
Email: Mahomed@CustodianDC.commailto:support@CustodianDC.com
Web:
www.CustodianDC.comhttp://www.custodiandc.com/
Status:
status.CustDC.nethttp://status.custdc.net/
[cid:image98c948.png@112a1189.765f4e73] ISO:27001 IS:567248
Click to view our email disclaimerhttp://www.custodiandc.com/disclaimer.txt