Openbravo Issue Tracking System - Modules
View Issue Details
0037554ModulesWarehouse Packingpublic2017-12-27 15:392019-01-24 16:39
JONHM 
Triage Omni WMS 
highmajorsometimes
scheduledopen 
5
 
 
0037554: Performance issue on Packing p&e when using high amount of data
There is a performance issue on Packing p&e when using high amount of data.
Having large volumes of products and boxes causes this problem.
Apparently, there is also a relation between the performance of this p&e window and the resolution of the screen.
Tested in Chrome version 63.0
The issue can be reproduced more clearly on a WebPOS environment which have more products, so the steps to reproduce are specified with 'The White Valley Group Admin' role

-- Install Warehouse Packing Module and log in 'The White Valley Group Admin' role

1) Open 'Sales Order' window:
  1.1) Create a new record for "Arturo Montoro"
  1.2) Press 'Copy From Orders' button, then select all the orders and press DONE
  1.3) Book the sales order

2) Open Goods Shipment window and create e new record for 'Arturo Montoro'. Then press button Create Lines From and select the previous SO. Then complete the Goods Shipment.

3) Resize the screen to simulate a smaller monitor and force the resizing of the pick and execute when loading (see attached video)

4) Press 'Pack' button and then scroll down several times. There's a slow performance when loading the lines.

Note: the higher the number of records, the slower the performance.
No tags attached.
? slowPerformancePacking.mp4 (2,171,086) 2017-12-27 15:39
https://issues.openbravo.com/file_download.php?file_id=11397&type=bug
Issue History
2017-12-27 15:39JONHMNew Issue
2017-12-27 15:39JONHMAssigned To => Triage Finance
2017-12-27 15:39JONHMFile Added: slowPerformancePacking.mp4
2017-12-27 15:39JONHMResolution time => 1516143600
2017-12-28 15:08rbianchiniIssue Monitored: rbianchini
2017-12-28 23:30eugeniIssue Monitored: eugeni
2018-01-04 09:16dmiguelezAssigned ToTriage Finance => collazoandy4
2018-01-04 23:09collazoandy4Statusnew => scheduled
2018-01-05 09:49dmiguelezAssigned Tocollazoandy4 => platform
2018-01-23 15:06alostaleAssigned Toplatform => Triage Finance
2018-01-23 15:08alostaleNote Added: 0101915
2018-01-25 16:32dmiguelezNote Added: 0101951
2018-01-25 16:32dmiguelezTypedefect => design defect
2018-02-02 11:24JONHMSummaryPerformance issue on Packing p&e when using small sized monitors => Performance issue on Packing p&e when using high amount of data
2018-02-02 11:24JONHMDescription Updatedbug_revision_view_page.php?rev_id=16621#r16621
2019-01-24 16:39jfrancesIssue Monitored: jfrances

Notes
(0101915)
alostale   
2018-01-23 15:08   
Reassigned to Triage Finance:

* This P&E is implemented as a manual UI SmartClient component
* Backend is returning the whole dataset without pagination
(0101951)
dmiguelez   
2018-01-25 16:32   
The problem with this issue is that the UI element used to create the boxes and include the products in them has not been designed to support large volumes.

The Boxes columns of the grid are dynamic fields, those are generated based on the number of boxes created, and it's values are calculated on the fly. This is why the grid also takes that long to open.

As the number of records grows or, as the number of boxes grows, the grid becomes less usable. Having hundreds of records and 5 boxes, or having 50-100 records and 20 boxes makes the grid really slow.

The proposed solution to fix this problem is to not use this grid when there are many records but use a pick&edit for each box instead.

The idea would be:
- The user clicks on Pack button, if there are many records in the lines, a message is shown to explain that there are many records and that the boxes must be created first manually.
- The boxes should be created manually for the existing tab
- Then, for each box, a new button with a new process should be created to do the packing of that box, removing the quantities already packed in other boxes.
This can be done using a normal Pick&Edit Window