id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc,workgroup 1162,Otimizar a query do método getChildren da classe wf_instance,gbisotto,viani,"Atualmente a query que retorna as instancias filhas de uma instancia demora em torno de 2 segundos. Em testes feitos com a query: SELECT i.wf_instance_id AS wf_instance_id, ia.wf_activity_id AS wf_activity_id, i.wf_started AS wf_started, i.wf_name AS wf_name, i.wf_status AS wf_status, ia.wf_user AS wf_user, ir.wf_parent_lock AS wf_parent_lock FROM egw_wf_interinstance_relations as ir LEFT JOIN egw_wf_instances as i ON i.wf_instance_id = ir.wf_parent_instance_id LEFT JOIN egw_wf_instance_activities as ia ON i.wf_instance_id = ia.wf_instance_id WHERE i.wf_instance_id = ? demoraram no máximo 60 ms.",defeito,closed,alta,Expresso 2.2,Workflow,trunk,média,fixed,,,