Support A2Billing :

provided by Star2Billing S.L.

Support A2Billing :
It is currently Tue Mar 19, 2024 11:06 am
Auto Dialer Software


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 
Offline

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 cc_receipt.id, username, cc_receipt.date,title,cc_receipt.status,total_price, cc_receipt.id FROM cc_receipt LEFT JOIN cc_card ON cc_card.id=id_card 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 = cc_receipt.id 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.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 1 post ] 
Hosted Voice Broadcast


All times are UTC


Who is online

Users browsing this forum: No registered users and 2 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:  
cron
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group