Otimizar a query do método getChildren da classe wf_instance

[gbisotto]

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.

[gbisotto]

Corrigido em [3160].

[viani]

Nova correção no método getChildren, implementada em [3164].