Merge lp:~camptocamp/openobject-addons/trunk-fix_1311004_account_move_line_index-afe into lp:openobject-addons

[Alexandre Fayolle - camptocamp]

improve reading account_move_lines by using an index on date, id matching _order

[Guewen Baconnier @ Camptocamp (gbaconnier-c2c)]

LGTM

review: Approve (code review)

[Yannick Vaucher @ Camptocamp (yvaucher-c2c)]

review: Approve (code review, no test)

Unmerged revisions

9366. By Alexandre Fayolle - camptocamp on 2014-04-22

[IMP] add an index on account_move_line(date, id)

=== modified file 'account/account_move_line.py'
--- account/account_move_line.py	2014-01-15 21:44:54 +0000
+++ account/account_move_line.py	2014-04-22 12:11:15 +0000
@@ -565,6 +565,9 @@
         cr.execute('SELECT indexname FROM pg_indexes WHERE indexname = \'account_move_line_journal_id_period_id_index\'')
         if not cr.fetchone():
             cr.execute('CREATE INDEX account_move_line_journal_id_period_id_index ON account_move_line (journal_id, period_id)')
+        cr.execute('SELECT indexname FROM pg_indexes WHERE indexname = %s', ('account_move_line_date_id_index',))
+        if not cr.fetchone():
+            cr.execute('CREATE INDEX account_move_line_date_id_index ON account_move_line (date DESC, id desc)')
         return res
 
     def _check_no_view(self, cr, uid, ids, context=None):