![alfredorz](/community/data/avatars/m/45/45750.jpg?1712821809)
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.
![1715862433395.png 1715862433395.png](https://www.jdelist.com/community/data/attachments/5/5525-936e7bb1db35cfd233b4d6854805b980.jpg)
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.
![1715862472424.png 1715862472424.png](https://www.jdelist.com/community/data/attachments/5/5526-60e7b9d4e2c2c256c87127c915cfc270.jpg)
And when I execute data request only in orchestrator (removing bsfn) it's very fast (1-2 seconds):
![1715862375448.png 1715862375448.png](https://www.jdelist.com/community/data/attachments/5/5523-5536f9e7b40437aa9dce66f64edc9667.jpg)
But when I iterate over datarequest to format location it's delay a lot (170-180 sec):
![1715862314159.png 1715862314159.png](https://www.jdelist.com/community/data/attachments/5/5522-4bc801208b505afd68bb53a206529c4b.jpg)
![1715862419242.png 1715862419242.png](https://www.jdelist.com/community/data/attachments/5/5524-8f3a29a35553c0c12ecf6c696e7161f8.jpg)
How I could improve the performance?
Best regards.