Ticket #1162 (closed defeito: fixed)

Opened 11 years ago

Last modified 11 years ago

Otimizar a query do método getChildren da classe wf_instance

Reported by: gbisotto Owned by: viani
Priority: alta Milestone: Expresso 2.2
Component: Workflow Version: trunk
Severity: média Keywords:
Cc: WorkGroup:

Description

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.

Change History

comment:1 Changed 11 years ago by gbisotto

  • Status changed from new to closed
  • Resolution set to fixed

Corrigido em [3160].

comment:2 Changed 11 years ago by viani

  • Milestone changed from Expresso 2.0.9 to Expresso 2.2

comment:3 Changed 11 years ago by viani

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

Note: See TracTickets for help on using tickets.