Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0041086 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Modules] Advanced Warehouse Operations | major | always | 2019-06-13 10:39 | 2019-10-16 13:14 | |||
Reporter | joniturralde93 | View Status | public | |||||
Assigned To | joniturralde93 | |||||||
Priority | urgent | Resolution | open | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Regression date | ||||||||
Regression introduced by commit | ||||||||
Regression level | ||||||||
Review Assigned To | ||||||||
Regression introduced in release | ||||||||
Summary | 0041086: Put away filter performance problem [Frontend] | |||||||
Description | Searching 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 Reproduce | 1. Open AWO Frontend 2. Menu -> Put Away 3. Filter some text (timeout will be thrown) | |||||||
Tags | No tags attached. | |||||||
Attached Files | Query [^] (2,403 bytes) 2019-06-13 10:39 [Show Content]
ExplainAnalyzeTEST [^] (7,276 bytes) 2019-06-13 10:40 [Show Content] 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 |