Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0041086
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Modules] Advanced Warehouse Operationsmajoralways2019-06-13 10:392019-10-16 13:14
Reporterjoniturralde93View Statuspublic 
Assigned Tojoniturralde93 
PriorityurgentResolutionopenFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Regression date
Regression introduced by commit
Regression level
Review Assigned To
Regression introduced in release
Summary

0041086: 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)
TagsNo tags attached.
Attached Files? file icon Query [^] (2,403 bytes) 2019-06-13 10:39 [Show Content]
? file icon ExplainAnalyzeTEST [^] (7,276 bytes) 2019-06-13 10:40 [Show Content]
jpg file icon Selection_604.jpg [^] (85,498 bytes) 2019-07-03 18:15

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0113159)
guilleaer (developer)
2019-07-03 18:14

Test disabling contains for put away (using preference)

image attached
(0113173)
joniturralde93 (developer)
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 (manager)
2019-07-16 16:44

After activate the preference "Use Contains for PUT" the problem has not been solved
(0115109)
joniturralde93 (developer)
2019-10-16 13:13

We can suppose that the backported preferences worked since they didn't give an answer on the ticket.

- Issue History
Date Modified Username Field Change
2019-06-13 10:39 joniturralde93 New Issue
2019-06-13 10:39 joniturralde93 Assigned To => Triage Finance
2019-06-13 10:39 joniturralde93 File Added: Query
2019-06-13 10:39 joniturralde93 Resolution time => 1562191200
2019-06-13 10:40 joniturralde93 File Added: ExplainAnalyzeTEST
2019-06-13 11:17 Sandrahuguet Assigned To Triage Finance => guilleaer
2019-07-03 18:14 guilleaer Note Added: 0113159
2019-07-03 18:14 guilleaer Assigned To guilleaer => joniturralde93
2019-07-03 18:14 guilleaer Status new => feedback
2019-07-03 18:15 guilleaer File Added: Selection_604.jpg
2019-07-04 12:19 joniturralde93 Note Added: 0113173
2019-07-16 16:44 egoitz Note Added: 0113440
2019-07-16 16:44 egoitz Status feedback => new
2019-10-16 13:13 joniturralde93 Note Added: 0115109
2019-10-16 13:13 joniturralde93 Status new => scheduled
2019-10-16 13:14 joniturralde93 Status scheduled => resolved
2019-10-16 13:14 joniturralde93 Status resolved => closed
2022-09-06 17:18 caristu Category Advance Warehouse Operations => Advanced Warehouse Operations


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker