** Branch linked: lp:~openerp-community/openobject-addons/trunk- btree_compute-vauxoo
-- You received this bug notification because you are a member of OpenERP Indian Team, which is subscribed to OpenERP Addons. https://bugs.launchpad.net/bugs/887376 Title: [6.0 & 6.1] [account] def compute needs optimization Status in OpenERP Addons (modules): Confirmed Bug description: The def compute of account module no use parent_right & parent_left fields for calculate sum(debit) & sum(credit) and not in use recursive function's These is very slow with a big account chart and very much account_move_line This can optimizate using parent_left & parent_right Im working for a propose merge with the solution. Meanwhile i put a script sql with my idea SELECT MIN(aa_tree_1.code) AS code, SUM(account_move_line.debit) AS debit, SUM(account_move_line.credit) AS credit FROM account_account aa_tree_1 INNER JOIN account_account aa_tree_2 ON aa_tree_2.parent_left BETWEEN aa_tree_1.parent_left AND aa_tree_1.parent_right INNER JOIN account_move_line ON account_move_line.account_id = aa_tree_2.id INNER JOIN account_move ON account_move.id = account_move_line.move_id AND account_move.state = 'posted' GROUP BY aa_tree_1.id These script is functionally without consolidate account, but I'm working To manage notifications about this bug go to: https://bugs.launchpad.net/openobject-addons/+bug/887376/+subscriptions _______________________________________________ Mailing list: https://launchpad.net/~openerp-india Post to : [email protected] Unsubscribe : https://launchpad.net/~openerp-india More help : https://help.launchpad.net/ListHelp
