c2c-oerpscenario team mailing list archive

[xrg <xrg@xxxxxxxxx>]

On Saturday 15 May 2010, you wrote:
> Public bug reported:
> 
> suggestion
> create index chricar_ir_ui_view_model_type_index on ir_ui_view(model,type);

Take note, we should consider commit 5b6e425151777eae

@Ferdninard: thanks

-- 
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);