Odoo Addons (MOVED TO GITHUB)

missing database index on account_move_line(date, id)

Bug #1311004 reported by Alexandre Fayolle - camptocamp on 2014-04-22

This bug affects 3 people

	Status	Importance	Assigned to
Odoo Addons (MOVED TO GITHUB)	Fix Released	Wishlist	Unassigned
OpenERP Community Backports (Addons)	Status tracked in 7.0
6.1	Fix Committed	Undecided	Unassigned
7.0	Fix Released	Undecided	Unassigned

Bug Description

I have seen huge performance improvements in production by adding an index on account_move_line(date, id) which corresponds to account_move_line default _order.

It would be great to have this index created by default.

Related branches

lp://staging/~camptocamp/ocb-addons/ocb-7.0-fix_1311004_account_move_line_index-afe

Merged into lp://staging/ocb-addons at revision 10129

Yannick Vaucher @ Camptocamp: Approve (code review, no test) on 2014-04-22

Stéphane Bidoul (Acsone) (community): Approve (code review) on 2014-04-22

Pedro Manuel Baeza: Approve (code review) on 2014-04-22

Guewen Baconnier @ Camptocamp: Approve (code review) on 2014-04-22

lp://staging/~camptocamp/openobject-addons/7.0-fix_1311004_account_move_line_index-afe

Ready for review for merging into lp://staging/openobject-addons/7.0

Yannick Vaucher @ Camptocamp (community): Approve (code review, no test) on 2014-04-22

Guewen Baconnier @ Camptocamp (community): Approve (code review) on 2014-04-22

OpenERP Core Team: Pending requested 2014-04-22

lp://staging/~camptocamp/openobject-addons/6.1-fix_1311004_account_move_line_index-afe

Ready for review for merging into lp://staging/openobject-addons/6.1

Yannick Vaucher @ Camptocamp (community): Approve (code review, no test) on 2014-04-22

Guewen Baconnier @ Camptocamp (community): Approve (code review) on 2014-04-22

OpenERP Core Team: Pending requested 2014-04-22

lp://staging/~camptocamp/openobject-addons/ocb-6.1-fix_1311004_account_move_line_index-afe

Superseded for merging into lp://staging/openobject-addons/6.1

Yannick Vaucher @ Camptocamp (community): Needs Resubmitting on 2014-04-22

Guewen Baconnier @ Camptocamp (community): Approve (code review) on 2014-04-22

OpenERP Core Team: Pending requested 2014-04-22

Diff: 3815 lines (+1494/-563)

78 files modified

account/__init__.py (+1/-1)
account/account.py (+59/-16)
account/account_invoice.py (+205/-39)
account/account_invoice_view.xml (+5/-1)
account/account_invoice_workflow.xml (+1/-1)
account/account_move_line.py (+3/-0)
account/account_view.xml (+1/-1)
account/company.py (+7/-1)
account/company_view.xml (+1/-0)
account/data/data_account_type.xml (+1/-0)
account/partner_view.xml (+1/-1)
account/report/account_aged_partner_balance.py (+9/-9)
account/report/account_print_invoice.rml (+14/-14)
account_analytic_analysis/account_analytic_analysis.py (+18/-33)
account_analytic_plans/account_analytic_plans_view.xml (+2/-2)
account_anglo_saxon/__openerp__.py (+1/-1)
account_anglo_saxon/account_anglo_saxon_demo.xml (+34/-0)
account_anglo_saxon/purchase.py (+7/-7)
account_asset/account_asset_invoice.py (+1/-0)
account_budget/account_budget.py (+17/-1)
account_payment/account_move_line.py (+2/-2)
account_payment/account_payment_view.xml (+1/-1)
analytic/analytic.py (+9/-12)
audittrail/audittrail.py (+16/-8)
base_action_rule/base_action_rule.py (+4/-1)
base_calendar/base_calendar.py (+27/-1)
base_contact/base_contact.py (+3/-1)
crm/crm_lead_view.xml (+2/-0)
crm/crm_meeting_view.xml (+3/-1)
crm/crm_phonecall_view.xml (+3/-1)
crm_claim/crm_claim_view.xml (+3/-1)
crm_fundraising/crm_fundraising_view.xml (+2/-0)
crm_helpdesk/crm_helpdesk_view.xml (+2/-1)
delivery/__openerp__.py (+1/-0)
delivery/stock.py (+12/-1)
delivery/test/delivery_chained_pickings.yml (+37/-0)
document/document.py (+18/-8)
fetchmail/fetchmail.py (+1/-1)
hr/hr.py (+2/-1)
hr_payroll/hr_payroll.py (+1/-1)
hr_recruitment/hr_recruitment_view.xml (+1/-1)
hr_timesheet/hr_timesheet.py (+1/-2)
hr_timesheet_invoice/hr_timesheet_invoice.py (+6/-3)
hr_timesheet_sheet/hr_timesheet_sheet.py (+1/-1)
l10n_nl/__openerp__.py (+3/-0)
l10n_nl/account_chart_netherlands.xml (+352/-244)
l10n_nl/account_fiscal_position_account_template.xml (+245/-0)
l10n_nl/account_fiscal_position_tax_template.xml (+97/-0)
l10n_nl/account_fiscal_position_template.xml (+33/-0)
mail/mail_message.py (+17/-4)
mail/mail_thread.py (+1/-1)
mrp/mrp.py (+24/-3)
mrp/security/mrp_security.xml (+1/-1)
mrp_repair/mrp_repair.py (+2/-1)
procurement/procurement.py (+1/-1)
product/pricelist.py (+48/-17)
product/product.py (+2/-2)
product/report/product_label.xsl (+1/-1)
project/project_view.xml (+2/-2)
project_issue/project_issue_view.xml (+1/-1)
project_mrp/project_procurement.py (+7/-3)
project_timesheet/project_timesheet.py (+7/-5)
purchase/purchase.py (+23/-16)
purchase/purchase_view.xml (+1/-1)
purchase/wizard/purchase_line_invoice.py (+13/-36)
purchase_requisition/wizard/purchase_requisition_partner_view.xml (+1/-1)
sale/report/sale_order.rml (+26/-26)
sale/report/sale_report_view.xml (+1/-1)
sale/sale.py (+9/-3)
sale/sale_view.xml (+3/-3)
stock/report/report_stock_move.py (+6/-1)
stock/stock.py (+2/-2)
stock/wizard/stock_return_picking.py (+13/-7)
users_ldap/users_ldap.py (+1/-1)
warning/warning.py (+2/-2)
wiki/wiki.py (+1/-0)
wiki/wizard/wiki_create_menu.py (+1/-0)
wiki/wizard/wiki_wiki_page_open.py (+1/-0)

lp://staging/~camptocamp/openobject-addons/trunk-fix_1311004_account_move_line_index-afe

Ready for review for merging into lp://staging/openobject-addons

Yannick Vaucher @ Camptocamp (community): Approve (code review, no test) on 2014-04-22

Guewen Baconnier @ Camptocamp (community): Approve (code review) on 2014-04-22

OpenERP Core Team: Pending requested 2014-04-22

lp://staging/~camptocamp/ocb-addons/6.1-fix_1311004_account_move_line_index-afe

Merged into lp://staging/ocb-addons/6.1 at revision 6842

Holger Brunn (Therp): Approve (code review) on 2014-04-28

Yannick Vaucher @ Camptocamp: Approve (code review, no test) on 2014-04-23

Pedro Manuel Baeza: Approve (code review) on 2014-04-23

Guewen Baconnier @ Camptocamp: Pending (code review) requested 2014-04-23

OpenERP Core Team: Pending requested 2014-04-23