Export general ledger is too long

[laetitia-gangloff]

Export general ledger is too long

[pedrobaeza]

Have you tried to put that part in SQL to see if the time is reduced?

[laetitia-gangloff]

Yes, I tried with the following method (instead of the existing one, easy-ugly fix) and the time is reduced (quasi immediate) :

    def _get_move_ids_from_periods(self, account_id, period_start, period_stop,
                                   target_move):
        period_obj = self.pool.get('account.period')
        periods = period_obj.build_ctx_periods(
            self.cursor, self.uid, period_start.id, period_stop.id)
        if not periods:
            return []
        move_state = ['draft', 'posted']
        if target_move == 'posted':
            move_state = ['posted', '']
        #return move_line_obj.search(self.cursor, self.uid, search)
        sql = """select aml.id
                 from account_move_line aml
                      LEFT JOIN account_move am ON (am.id = aml.move_id)
                 where aml.period_id in %s
                 and aml.account_id = %s
                 and am.state IN %s
        """
        self.cursor.execute(sql, (tuple(periods), account_id,
                                  tuple(move_state)))
        res = self.cursor.fetchall()
        return res

[laetitia-gangloff]

I also tried to set auto_join=True on the column move_id of account.move.line and the result is also quasi immediate.

[laetitia-gangloff]

I proposed the following PR to odoo (to add auto_join):
odoo/odoo#5573

[laetitia-gangloff]

PR is closed, so I closed this issue.