c2c-oerpscenario team mailing list archive

Thread
Date

[Bug 580852] Re: performance ir_ui_view index missing

To: c2c-oerpscenario@xxxxxxxxxxxxxxxxxxx
From: "Fabien \(Open ERP\)" <fp@xxxxxxxxxxx>
Date: Mon, 08 Nov 2010 21:16:26 -0000
Reply-to: Bug 580852 <580852@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx

** Changed in: openobject-server
   Importance: Undecided => Low

** Changed in: openobject-server
       Status: New => Confirmed

** Changed in: openobject-server
     Assignee: (unassigned) => OpenERP's Framework R&D (openerp-dev-framework)

-- 
performance ir_ui_view index missing
https://bugs.launchpad.net/bugs/580852
You received this bug notification because you are a member of C2C
OERPScenario, which is subscribed to the OpenERP Project Group.

Status in OpenObject Server: Confirmed

Bug description:
branch and trunk

no index - full table scan 

SELECT arch,name,field_parent,id,type,inherit_id FROM ir_ui_view WHERE model=e{} AND type=e{} AND inherit_id is null ORDER BY priority 

suggestion
create index chricar_ir_ui_view_model_type_index on ir_ui_view(model,type);