performance ir_ui_view index missing

[Ferdinand]

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

[xrg (xrg)]

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

[Olivier Dony (Odoo) (odo-openerp)]

Thanks for the report, this was an important one indeed!

The fix has landed in revision 3088 - <email address hidden>, along with other similar missing indices in view-related tables: http://bit.ly/hpzldo