mirror of
https://gitlab.com/flectra-community/account-financial-reporting.git
synced 2024-11-22 13:42:07 +00:00
31 lines
1.2 KiB
Python
31 lines
1.2 KiB
Python
# Copyright 2019 ACSONE SA/NV (<http://acsone.eu>)
|
|
# License AGPL-3.0 or later (http://www.gnu.org/licenses/agpl.html).-
|
|
from flectra import api, models
|
|
|
|
|
|
class AccountMoveLine(models.Model):
|
|
_inherit = 'account.move.line'
|
|
|
|
@api.model_cr
|
|
def init(self):
|
|
"""
|
|
The join between accounts_partners subquery and account_move_line
|
|
can be heavy to compute on big databases.
|
|
Join sample:
|
|
JOIN
|
|
account_move_line ml
|
|
ON ap.account_id = ml.account_id
|
|
AND ml.date < '2018-12-30'
|
|
AND ap.partner_id = ml.partner_id
|
|
AND ap.include_initial_balance = TRUE
|
|
By adding the following index, performances are strongly increased.
|
|
:return:
|
|
"""
|
|
self._cr.execute('SELECT indexname FROM pg_indexes WHERE indexname = '
|
|
'%s',
|
|
('account_move_line_account_id_partner_id_index',))
|
|
if not self._cr.fetchone():
|
|
self._cr.execute("""
|
|
CREATE INDEX account_move_line_account_id_partner_id_index
|
|
ON account_move_line (account_id, partner_id)""")
|