asterisk2billing.org http://forum.asterisk2billing.org/ |
|
Very heavy data not loading in a2billing http://forum.asterisk2billing.org/viewtopic.php?f=14&t=10594 |
Page 1 of 1 |
Author: | jagruti [ Wed Nov 13, 2013 2:06 pm ] |
Post subject: | Very heavy data not loading in a2billing |
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. |
Page 1 of 1 | All times are UTC |
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group http://www.phpbb.com/ |