[PERF] account_invoice_change_currency: Slow query from domain #469

moylop260 · 2018-12-21T19:26:02Z

The following line of code:

account-invoicing/account_invoice_change_currency/models/account_change_currency.py

Line 115 in 7cb1413

domain += [('mail_message_id.subtype_id', '!=', subtype_id.id)]

Run the following sql query:

SELECT mail_message.id FROM mail_message WHERE (mail_message.subtype_id != 58) ORDER BY mail_message.id DESC;

This is so slow (2s) because the result is too big if you have too many records.
After that will process the result of all ids fetched for a second query, then it is so slow.

@hugho-ad
Could you help us, please?

The text was updated successfully, but these errors were encountered:

id, instead search them by messages ids then filter them fix OCA#469

hugho-ad · 2018-12-24T17:59:36Z

@moylop260
FYI
#470

id, instead search them by messages ids then filter them fix OCA#469 [REF] account_invoice_change_currency: Sql queries in order to improve performance [FIX] account_invoice_change_currency: Fixed tests

#470) id, instead search them by messages ids then filter them fix #469 [REF] account_invoice_change_currency: Sql queries in order to improve performance [FIX] account_invoice_change_currency: Fixed tests

OCA#470) id, instead search them by messages ids then filter them fix OCA#469 [REF] account_invoice_change_currency: Sql queries in order to improve performance [FIX] account_invoice_change_currency: Fixed tests

hugho-ad mentioned this issue Dec 24, 2018

[FIX] Fixed performance problem when searchn tracking values by subty… #470

Merged

hugho-ad added a commit to vauxoo-dev/account-invoicing that referenced this issue Dec 24, 2018

[FIX] Fixed performance problem when search tracking values by subtype

c743043

id, instead search them by messages ids then filter them fix OCA#469

moylop260 closed this as completed Jan 7, 2019

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

[PERF] account_invoice_change_currency: Slow query from domain #469

[PERF] account_invoice_change_currency: Slow query from domain #469

moylop260 commented Dec 21, 2018 •

edited

Loading

hugho-ad commented Dec 24, 2018

[PERF] account_invoice_change_currency: Slow query from domain #469

[PERF] account_invoice_change_currency: Slow query from domain #469

Comments

moylop260 commented Dec 21, 2018 • edited Loading

hugho-ad commented Dec 24, 2018

moylop260 commented Dec 21, 2018 •

edited

Loading