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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0033569
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2016-07-29 15:132016-12-07 09:36
ReporterlorenzofidalgoView Statuspublic 
Assigned ToNaroaIriarte 
PriorityurgentResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionmainSCM revision 
Merge Request Status
Review Assigned Toalostale
OBNetwork customerNo
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0033569: [RR16Q3][HighVol] Product selector is pretty slow in a Store Server configuration

DescriptionTrying to get product values is slow (approximately 32 seconds). I have reproduced this situation in a Store server configuration with two store servers and one central server. One of the tests executed killed Chrome tab waiting for Product Selector. (Check attached videos and screenshot).
[1] https://drive.google.com/a/openbravo.com/file/d/0Bz1bUfkEffVIbDJZczl4di03SmM/view?usp=sharing [^]
[2] https://drive.google.com/a/openbravo.com/file/d/0Bz1bUfkEffVIUzlEUE5CRERteVk/view?usp=sharing [^]
Steps To Reproduce0-Using a Store server configuration with two store servers and one central server login Store server as Openbravo.
1-Using "The White Valley Group Admin" as Role, go to "Sales Order" window.
2-Click create new record button and fill the record with the following data:
--
Organization: Vall Blanca Store
Transaction Document: VBS POS Order
Business Partner: Arturo Montoro
--
Save that record.
3-Go to "Lines" tab and press Ctrl + i to create a new record
4-In Product field, click magnifier. Realise this query takes too much time.
5-After, approximately, 32 seconds, values will be shown. Now click Clear Filters button and wait. Realise, again, it takes too long.
TagsPerformance
Attached Filespng file icon ProductKillsOB.png [^] (241,590 bytes) 2016-07-29 15:13

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to feature request 0033015 closedcaristu Performance Improvements in Product Selector 

-  Notes
(0091380)
lorenzofidalgo (viewer)
2016-11-11 10:22

 This issue is still reproducible in RR16Q4
(0092158)
NaroaIriarte (viewer)
2016-12-07 09:35

 A vacuum full and an analyze has been executed in the database and now, the selector performs correctly.

- Issue History
Date Modified Username Field Change
2016-07-29 15:13 lorenzofidalgo New Issue
2016-07-29 15:13 lorenzofidalgo Assigned To => platform
2016-07-29 15:13 lorenzofidalgo File Added: ProductKillsOB.png
2016-07-29 15:13 lorenzofidalgo OBNetwork customer => No
2016-07-29 15:13 lorenzofidalgo Web browser => Google Chrome
2016-07-29 15:13 lorenzofidalgo Modules => Core
2016-07-29 15:13 lorenzofidalgo Triggers an Emergency Pack => No
2016-07-29 15:14 lorenzofidalgo Tag Attached: Performance
2016-11-11 10:22 lorenzofidalgo Note Added: 0091380
2016-11-11 10:22 lorenzofidalgo Web browser Google Chrome => Google Chrome
2016-11-11 10:22 lorenzofidalgo Priority normal => high
2016-11-30 10:16 NaroaIriarte Assigned To platform => NaroaIriarte
2016-11-30 10:16 NaroaIriarte Status new => acknowledged
2016-11-30 10:17 NaroaIriarte Status acknowledged => scheduled
2016-12-01 13:17 alostale Priority high => urgent
2016-12-07 09:33 NaroaIriarte Status scheduled => acknowledged
2016-12-07 09:33 NaroaIriarte Status acknowledged => scheduled
2016-12-07 09:35 NaroaIriarte Review Assigned To => alostale
2016-12-07 09:35 NaroaIriarte Note Added: 0092158
2016-12-07 09:35 NaroaIriarte Status scheduled => closed
2016-12-07 09:35 NaroaIriarte Resolution open => no change required
2016-12-07 09:36 NaroaIriarte Relationship added related to 0033015

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker