← Back to team overview

openerp-india team mailing list archive

[Bug 901474] Re: Performance issue - missing index for _order

 

IMHO it would be convenient if 
* _order 
and
* m2o
would automagically create an index

-- 
You received this bug notification because you are a member of OpenERP
Indian Team, which is subscribed to OpenERP Addons.
https://bugs.launchpad.net/bugs/901474

Title:
  Performance issue - missing index for _order

Status in OpenERP Addons (modules):
  Confirmed

Bug description:
  
  IMHO all big tables (with some 1000 records to be sorted) need a multicolumn  index  on the columns defined in the order clauses to avoid full table scans, most o2m will not need it, as m will be a small number. nevertheless the column pointing to the parent should be indexed by default

  please check

  ./account/account_bank_statement.py:128:    _order = "date desc, id desc"
  ./account/account_bank_statement.py:453:    _order = "statement_id desc, sequence"
  ./account/account_move_line.py:568:    _order = "date desc, id desc"
  ./account/account.py:2556:    _order = 'code,name'
  ./account/account.py:675:    _order = "view_id, sequence"
  ./account/account.py:862:    _order = "date_start, id"
  ./account/account.py:960:    _order = "date_start, special desc"
  ./account_analytic_plans/account_analytic_plans.py:83:    _order = "sequence, id"
  ./account_invoice_layout/account_invoice_layout.py:151:    _order = "invoice_id, sequence asc"
  ./account/report/account_report.py:218:    _order = 'name desc,amount_total desc'
  ./account/report/account_report.py:260:    _order = 'name desc,amount_total desc'
  ./account_voucher/account_voucher.py:192:    _order = "date desc, id desc"
  ./auction/auction.py:236:    _order = "obj_num,lot_num,id"
  ./base_contact/base_contact.py:78:    _order = "name,first_name"
  ./base_report_creator/base_report_creator.py:549:    _order = "sequence,id"
  ./board/board.py:177:    _order = 'position,sequence'
  ./crm_claim/crm_claim.py:44:    _order = "priority,date desc"
  ./crm/crm_lead.py:42:    _order = "priority,date_action,id desc"
  ./hr_expense/hr_expense.py:275:    _order = "sequence, date_value desc"
  ./hr_holidays/hr_holidays.py:95:    _order = "type desc, date_from asc"
  ./hr_payroll/hr_payroll.py:730:    _order = 'payslip_id, sequence'
  ./hr_payroll/hr_payroll.py:751:    _order = 'payslip_id, sequence'
  ./hr_payroll/hr_payroll.py:920:    _order = 'contract_id, sequence'
  ./hr_timesheet_invoice/report/hr_timesheet_invoice_report.py:125:    _order = 'name desc,account_id desc,user_id desc'
  ./hr_timesheet_invoice/report/hr_timesheet_invoice_report.py:158:    _order = 'name desc,account_id desc,user_id desc'
  ./hr_timesheet_invoice/report/hr_timesheet_invoice_report.py:43:    _order = 'name desc,user_id desc'
  ./hr_timesheet_invoice/report/hr_timesheet_invoice_report.py:91:    _order = 'name desc,user_id desc'
  ./hr_timesheet_invoice/report/report_analytic.py:80:    _order = 'name desc, product_id asc, account_id asc'
  ./idea/idea.py:64:    _order = 'parent_id,name asc'
  ./mrp/mrp.py:497:    _order = 'priority desc, date_planned asc';
  ./mrp_operations/mrp_operations.py:86:    _order = "sequence, date_planned"
  ./procurement/procurement.py:84:    _order = 'priority,date_planned desc'
  ./product/pricelist.py:381:    _order = "sequence, min_quantity desc"
  ./product/product.py:228:    _order = "sequence, name"
  ./product/product.py:487:    _order = 'default_code,name_template'
  ./project_gtd/project_gtd.py:38:    _order = "sequence, name"
  ./project_issue/project_issue.py:48:    _order = "priority, create_date desc"
  ./project_long_term/project_long_term.py:133:    _order = "project_id, date_start, sequence"
  ./project_planning/project_planning.py:208:    _order = 'user_id, account_id'
  ./project_planning/project_planning.py:485:    _order = 'planning_id,user_id'
  ./project/project.py:656:    _order = "priority, sequence, date_start, name, id"
  ./project/report/project_report.py:59:    _order = 'name desc, project_id'
  ./purchase/report/purchase_report.py:71:    _order = 'name desc,price_total desc'
  ./resource/resource.py:224:    _order = 'dayofweek, hour_from'
  ./sale_layout/sale_layout.py:109:    _order = "order_id, sequence asc"
  ./sale/sale.py:956:    _order = 'sequence, id'
  ./stock/stock.py:1482:    _order = 'date_expected desc, id'
  ./wiki/wiki.py:104:    _order = 'section,create_date desc'

To manage notifications about this bug go to:
https://bugs.launchpad.net/openobject-addons/+bug/901474/+subscriptions


References