c2c-oerpscenario team mailing list archive

["Olivier Dony \(OpenERP\)" <580852@xxxxxxxxxxxxxxxxxx>]

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

The fix has landed in revision 3088 -
odo@xxxxxxxxxxx-20101210124716-okrkdqato09utpvx, along with other
similar missing indices in view-related tables: http://bit.ly/hpzldo

** Changed in: openobject-server
       Status: Confirmed => Fix Released

** Changed in: openobject-server
    Milestone: None => 6.0-rc2

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

Title:
  performance ir_ui_view index missing

Status in OpenObject Server:
  Fix Released

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