** Summary changed: - product performance issue - missing index for _order = 'default_code,name_template' + Performance issue - missing index for _order = 'default_code,name_template'
** Summary changed: - Performance issue - missing index for _order = 'default_code,name_template' + Performance issue - missing index for _order -- You received this bug notification because you are a member of C2C OERPScenario, which is subscribed to OpenERP Project Group. 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 _______________________________________________ Mailing list: https://launchpad.net/~c2c-oerpscenario Post to : [email protected] Unsubscribe : https://launchpad.net/~c2c-oerpscenario More help : https://help.launchpad.net/ListHelp
