Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035109Retail ModulesWeb POSpublic2017-01-31 14:472017-04-06 17:55
Reporterlorenzofidalgo 
Assigned Tomigueldejuana 
PriorityhighSeveritymajorReproducibilityalways
StatusscheduledResolutionopen 
PlatformOS5OS Version
Product Versionmain 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035109: [RR17Q1][StoreServer][HighVol] Adding products to the receipt is too slow
DescriptionPerformance when products are being added is too slow. This behaviour induces some issues like this one [1] where the added products can be added to a different receipt if the user continues working with the application.
[1] https://issues.openbravo.com/view.php?id=35108 [^]

This behaviour has been reproduced in a 17Q1 Retail context with a Store Server architecture with High Vol.
I have tested that performance delay is not so significant in a 17Q1 Retail context without Store Server or High Vol architecture.
It can be watched here: https://drive.google.com/a/openbravo.com/file/d/0Bz1bUfkEffVIUWlvYzhlLVhvREk/view?usp=sharing [^] [^]
Steps To Reproduce0-Login POS as vallblanca.
1-Click in several products quickly. DEFECT: Products will be added slowly.
Proposed Solution
Additional Information
TagsPerformance
Relationships
related to defect 0035025 closed ebecerra Multiple and unnecessary requests to BPLocation in new business partner selector 
related to defect 0035108 new Retail [RR17Q1][StoreServer][HighVol] It is possible to add products to a receipt different to the right one 
causes defect 0035120 acknowledged Retail Going to Cashup just after adding some products can throw uncaught exceptions 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-01-31 14:47lorenzofidalgoNew Issue
2017-01-31 14:47lorenzofidalgoAssigned To => Retail
2017-01-31 14:47lorenzofidalgoTriggers an Emergency Pack => No
2017-01-31 14:47lorenzofidalgoTag Attached: Performance
2017-01-31 14:52lorenzofidalgoRelationship addedrelated to 0035108
2017-01-31 14:53lorenzofidalgoDescription Updatedbug_revision_view_page.php?rev_id=14408#r14408
2017-02-01 10:28lorenzofidalgoRelationship addedcauses 0035120
2017-03-17 09:30SandrahuguetRelationship addedrelated to 0035025
2017-03-28 16:18mario_castelloAssigned ToRetail => mario_castello
2017-04-03 20:41mario_castelloAssigned Tomario_castello => Retail
2017-04-06 17:42marvintmNote Added: 0095872
2017-04-06 17:55marvintmStatusnew => scheduled
2017-04-06 17:55marvintmAssigned ToRetail => migueldejuana

Notes
(0095872)
marvintm   
2017-04-06 17:42   
The main cause in the slowness of this part is the code which is responsible of inserting the characteristics in the local database every time a product is added to the ticket.

This code most likely needs to be refactored to execute one single query to find out the currently available characteristics, instead of checking each characteristic individually.