Picking terminal: takes a lot of time to fetch the quick actions where there are A LOT of shipment schedules

teosarca commented 6 years ago

Is this a bug or feature request?

follow-up of https://github.com/metasfresh/metasfresh-webui-api/issues/925

What is the current behavior?

Which are the steps to reproduce?

consider you have a lot of shipment schedules; in my test i had ~1600
select a line and check how much took for quick actiosn to be displayed (ok, usually it's not so dramatic but i was using a remote database - JDBC over VPN)

What is the expected or desired behavior?

shall be fast

Note to dev

i found out de.metas.ui.web.picking.pickingslot.process.WEBUI_Picking_With_M_Source_HU_Base.checkSourceHuPrecondition() is very very slow.

metas-mk commented 6 years ago

@teosarca checked on environments w/ only 15 rows and not JDBC over VPN. Opening PickingSlot view: 4,2sec

Opening HU to Pick: 2,4sec + 20,1sec

teosarca commented 6 years ago

also, i've found that HU loading is quite slow. (to be debugged/profiled from de.metas.ui.web.picking.pickingslot.PickingSlotViewRepository.retrieveRows(PickingSlotRepoQuery))

metasfresh / metasfresh-webui-api-legacy