alfredorz
Reputable Poster
Hi folks,
I've done a very simple orchestrator, with a Data Request to F4101 by business unit and Putaway Zone in a list.
When I execute database query is very fast:
SELECT COUNT(*) FROM DEVDTA920P.F4100 WHERE TRIM(LMMCU) = '4800' AND LMPZON IN ('A','B','C','D','S','Z','W');
Return about 7.448 rows.
And when I execute data request only in orchestrator (removing bsfn) it's very fast (1-2 seconds):
But when I iterate over datarequest to format location it's delay a lot (170-180 sec):
How I could improve the performance?
Best regards.
I've done a very simple orchestrator, with a Data Request to F4101 by business unit and Putaway Zone in a list.
When I execute database query is very fast:
SELECT COUNT(*) FROM DEVDTA920P.F4100 WHERE TRIM(LMMCU) = '4800' AND LMPZON IN ('A','B','C','D','S','Z','W');
Return about 7.448 rows.
And when I execute data request only in orchestrator (removing bsfn) it's very fast (1-2 seconds):
But when I iterate over datarequest to format location it's delay a lot (170-180 sec):
How I could improve the performance?
Best regards.