Openbravo Issue Tracking System - Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0041086ModulesAdvanced Warehouse Operationspublic2019-06-13 10:392019-10-16 13:14
Reporterjoniturralde93 
Assigned Tojoniturralde93 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Support ticket
OBNetwork customer
Regression introduced in release
Summary0041086: Put away filter performance problem [Frontend]
DescriptionSearching with this filter can be very slow (in customer environment timeout is thrown). Attached query (built in Inventory.java) and explain analyze in customer test environment.

Query result gets cached in local so only the first time is slow, but in their environment it's always slow.
Steps To Reproduce1. Open AWO Frontend
2. Menu -> Put Away
3. Filter some text (timeout will be thrown)
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files? Query (2,403) 2019-06-13 10:39
https://issues.openbravo.com/file_download.php?file_id=13016&type=bug
? ExplainAnalyzeTEST (7,276) 2019-06-13 10:40
https://issues.openbravo.com/file_download.php?file_id=13017&type=bug
jpg Selection_604.jpg (85,498) 2019-07-03 18:15
https://issues.openbravo.com/file_download.php?file_id=13083&type=bug
jpg
Issue History
Date ModifiedUsernameFieldChange
2019-06-13 10:39joniturralde93New Issue
2019-06-13 10:39joniturralde93Assigned To => Triage Finance
2019-06-13 10:39joniturralde93File Added: Query
2019-06-13 10:39joniturralde93Resolution time => 1562191200
2019-06-13 10:40joniturralde93File Added: ExplainAnalyzeTEST
2019-06-13 11:17SandrahuguetAssigned ToTriage Finance => guilleaer
2019-07-03 18:14guilleaerNote Added: 0113159
2019-07-03 18:14guilleaerAssigned Toguilleaer => joniturralde93
2019-07-03 18:14guilleaerStatusnew => feedback
2019-07-03 18:15guilleaerFile Added: Selection_604.jpg
2019-07-04 12:19joniturralde93Note Added: 0113173
2019-07-16 16:44egoitzNote Added: 0113440
2019-07-16 16:44egoitzStatusfeedback => new
2019-10-16 13:13joniturralde93Note Added: 0115109
2019-10-16 13:13joniturralde93Statusnew => scheduled
2019-10-16 13:14joniturralde93Statusscheduled => resolved
2019-10-16 13:14joniturralde93Statusresolved => closed
2022-09-06 17:18caristuCategoryAdvance Warehouse Operations => Advanced Warehouse Operations

Notes
(0113159)
guilleaer   
2019-07-03 18:14   
Test disabling contains for put away (using preference)

image attached
(0113173)
joniturralde93   
2019-07-04 12:19   
Customer didn't have these preferences so we applied the changes and they worked.
Some tests were done in local and provided the changes to the partner and explained how the preferences work. Now we are pending for them to try the preferences:
- Use Contains for PUT
- Use Strict Search for PUT
(0113440)
egoitz   
2019-07-16 16:44   
After activate the preference "Use Contains for PUT" the problem has not been solved
(0115109)
joniturralde93   
2019-10-16 13:13   
We can suppose that the backported preferences worked since they didn't give an answer on the ticket.