missing database index on account_move_line(date, id)
Bug #1311004 reported by
Alexandre Fayolle - camptocamp
This bug affects 3 people
| Affects | Status | Importance | Assigned to | Milestone | ||
|---|---|---|---|---|---|---|
| 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_
It would be great to have this index created by default.
Related branches
lp:~camptocamp/ocb-addons/ocb-7.0-fix_1311004_account_move_line_index-afe
- Yannick Vaucher @ Camptocamp: Approve (code review, no test)
- Stéphane Bidoul (Acsone) (community): Approve (code review)
- Pedro Manuel Baeza: Approve (code review)
- Guewen Baconnier @ Camptocamp: Approve (code review)
-
Diff: 13 lines (+3/-0)1 file modifiedaccount/account_move_line.py (+3/-0)
lp:~camptocamp/openobject-addons/7.0-fix_1311004_account_move_line_index-afe
- Yannick Vaucher @ Camptocamp (community): Approve (code review, no test)
- Guewen Baconnier @ Camptocamp (community): Approve (code review)
- OpenERP Core Team: Pending requested
-
Diff: 13 lines (+3/-0)1 file modifiedaccount/account_move_line.py (+3/-0)
lp:~camptocamp/openobject-addons/6.1-fix_1311004_account_move_line_index-afe
- Yannick Vaucher @ Camptocamp (community): Approve (code review, no test)
- Guewen Baconnier @ Camptocamp (community): Approve (code review)
- OpenERP Core Team: Pending requested
-
Diff: 13 lines (+3/-0)1 file modifiedaccount/account_move_line.py (+3/-0)
lp:~camptocamp/openobject-addons/ocb-6.1-fix_1311004_account_move_line_index-afe
- Yannick Vaucher @ Camptocamp (community): Needs Resubmitting
- Guewen Baconnier @ Camptocamp (community): Approve (code review)
- OpenERP Core Team: Pending requested
-
Diff: 3815 lines (+1494/-563)78 files modifiedaccount/__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:~camptocamp/openobject-addons/trunk-fix_1311004_account_move_line_index-afe
- Yannick Vaucher @ Camptocamp (community): Approve (code review, no test)
- Guewen Baconnier @ Camptocamp (community): Approve (code review)
- OpenERP Core Team: Pending requested
-
Diff: 13 lines (+3/-0)1 file modifiedaccount/account_move_line.py (+3/-0)
lp:~camptocamp/ocb-addons/6.1-fix_1311004_account_move_line_index-afe
- Holger Brunn (Therp): Approve (code review)
- Yannick Vaucher @ Camptocamp: Approve (code review, no test)
- Pedro Manuel Baeza: Approve (code review)
- Guewen Baconnier @ Camptocamp: Pending (code review) requested
- OpenERP Core Team: Pending requested
-
Diff: 13 lines (+3/-0)1 file modifiedaccount/account_move_line.py (+3/-0)
Revision history for this message
| Stéphane Bidoul (Acsone) (sbi) wrote | #1 |
Revision history for this message
| Olivier Dony (Odoo) (odo-openerp) wrote | #2 |
| Changed in openobject-addons: | |
| importance: | Undecided → Wishlist |
| status: | New → Fix Released |
To post a comment you must log in.
Hello Alexandre,
Out of curiosity, are there specific scenarios which benefit from this new index, or is this a general performance improvement?
-sbi