missing database index on account_move_line(date, id)

Bug #1311004 reported by Alexandre Fayolle - camptocamp on 2014-04-22
16
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
Undecided
Unassigned
7.0
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

Revision history for this message
Stéphane Bidoul (Acsone) (sbi) wrote :

Hello Alexandre,

Out of curiosity, are there specific scenarios which benefit from this new index, or is this a general performance improvement?

-sbi

Revision history for this message
Olivier Dony (Odoo) (odo-openerp) wrote :
Changed in openobject-addons:
importance: Undecided → Wishlist
status: New → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers