Is anyone out there using the billing feature with more than 64 bills (customers)?
I could be barking up the wrong tree, but I've done some experimenting by changing the query in bills.inc.php to call specific bills. If I give it 63 bills and call the page, regardless of how many times I do it, it comes up in less than 5 seconds. But if I give it 64 or more, then I am looking of 70+ seconds for the page to be generated. It doesn't matter which bill_ID I use so it doesn't seem to be a problem with a specific ID.
Also, can anyone please tell me what the values at the bottom of the page mean? Below are two examples, one when it returns the page quickly and the other slowly.
MySQL: Cell 60/0.003s Row 387/0.026s Rows 7/0s Column 180/2.239s MySQL: Cell 61/0.004s Row 393/24.614s Rows 7/0.645s Column 183/44.798s
Kind regards,
Mahomed Hussein Senior Operations Engineer Custodian DataCentre tel: +44 (0)1622 230382 email: Mahomed@CustodianDC.com http://www.custodiandc.com/disclaimer.txt
-----Original Message----- From: observium-bounces@observium.org [mailto:observium-bounces@observium.org] On Behalf Of Mahomed Hussein Sent: 22 September 2011 10:48 To: Observium Network Observation System Subject: Re: [Observium] Traffic bills page taking over a minute to display
Hi
Thanks for the response. I am not entirely sure which queries to run, but I've run "select * from bills" using the Execute SQL section of WebMin and that returns the results almost immediately. So it doesn't seem to be an issue with that query. If you can point me at which file or queries to run, I can test them further. Thanks.
Kind regards,
Mahomed Hussein Senior Operations Engineer Custodian DataCentre tel: +44 (0)1622 230382 email: Mahomed@CustodianDC.com http://www.custodiandc.com/disclaimer.txt
-----Original Message----- From: observium-bounces@observium.org [mailto:observium-bounces@observium.org] On Behalf Of Dirk-Willem van Gulik Sent: 21 September 2011 15:11 To: Observium Network Observation System Subject: Re: [Observium] Traffic bills page taking over a minute to display
On 21 Sep 2011, at 15:08, Mahomed Hussein wrote:
Can anyone please help or provide some tips of where to start checking? It now becoming pretty unusable.
Have you looked at the SQL query ? How long that takes if you do it manually from the mysql cmnd tool ?
That gives you an idea as to where to start looking,
Dw.
Kind regards,
Mahomed Hussein
Senior Operations Engineer
image8c376c.jpg@5c3feea6.0860423b
Tel:
+44 (0)1622 230 382
Email:
Mahomed@CustodianDC.com Web:
www.CustodianDC.com
Status:
status.CustDC.net
imagea72a25.png@94a57a1c.c10e4664 ISO:27001 IS:567248
Click to view our email disclaimer
From: Mahomed Hussein Sent: 31 August 2011 09:52 To: 'observium@observium.org' Subject: Traffic bills page taking over a minute to display
Hi
We've been adding customers to the billing section and after a strange occurrence a few weeks ago (which we attributed to time changes between the VM and the ESX host), the billing page has been very slow to generate. Please could you let me know if there is anything I can do to check/fix the problem?
Below is how long the most recent page display took:
MySQL: Cell 63/0s Row 404/38.23s Rows 8/0.65s Column 189/56.87s Generated in 95.36 seconds.
This is happening in the latest dev release of Google Chrome, Opera 11.50 and IE9 (I haven't tested firefox).
I have already rebooted the server.
Below is the system information.
Observium 0.11.8.2404 Apache 2.2.17 (Ubuntu) PHP 5.3.5-1ubuntu7.2 MySQL 5.1.54-1ubuntu4
Any help will be sincerely appreciated.
Kind regards,
observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium This e-mail has been scanned by www.CustodianDC.com for viruses, explicit material and spam
_______________________________________________ observium mailing list observium@observium.org http://postman.memetic.org/cgi-bin/mailman/listinfo/observium