Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Mon Dec 11, 2023 12:04 am
VoIP Billing solution

All times are UTC

Post new topic Reply to topic  [ 1 post ] 
Author Message
 Post subject: Very heavy data not loading in a2billing
PostPosted: Wed Nov 13, 2013 2:06 pm 

Joined: Wed Nov 13, 2013 1:45 pm
Posts: 1
Hello All,

I am using a2billing version 1.8.1.I have around 250000 records in cc_receipt_item.When i open the receipt page from portal
then it takes much time and i can not see the data in page even if waiting 4 to 5 hours.
When i have checked from mysql processlist then it shows me there is 1 query is locked.
The query which is used for get the data in receipt page and show me as locked in processlist is
"SELECT SQL_CALC_FOUND_ROWS, username,,title,cc_receipt.status,total_price, FROM cc_receipt LEFT JOIN cc_card ON LEFT JOIN ( SELECT st1.id_receipt, SUM(st1.price) as total_price FROM cc_receipt_item AS st1 GROUP BY st1.id_receipt) as items ON items.id_receipt = ORDER BY id DESC LIMIT 0,10".
If i keep 800 records in cc_receipt_item then it will show the data in receipt page from portal.
Can you please help me how to resolve this problem?
I have also tried with upgreading the a2billing version to 2.0.6.But still same issue faced.
Does anybody know how to optimize this query or any other solution?.
Thanks in advance.

Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 
Predictive Dialer

All times are UTC

Who is online

Users browsing this forum: No registered users and 10 guests

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group