Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037577Retail ModulesWeb POSpublic2018-01-03 14:232018-02-06 18:24
Reporterumartirena 
Assigned Tojorge-garcia 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR18Q2 
Merge Request Status
Review Assigned Tomarvintm
OBNetwork customer
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0037577: Performance issues in Web POS while working with big amount of manual Discount (9.000)
DescriptionPerformance issues in Web POS while working with big amount of manual Discount (9.000).
Steps To ReproduceLoad 9.000 manual discounts in Web POS.
Login in Web POS.
Add a line.
Check that it takes around a minute to add the line and the Web POS freezes in the mean time.
Proposed SolutionOB.UTIL.isDisableDiscount function is the source of the problem. Make a count(*) instead of returning all the records of the query.
Additional Information
TagsPerformance
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2018-01-03 14:23umartirenaNew Issue
2018-01-03 14:23umartirenaAssigned To => Retail
2018-01-03 14:23umartirenaTriggers an Emergency Pack => No
2018-01-03 15:04SandrahuguetTag Attached: Performance
2018-01-03 16:05jorge-garciaStatusnew => scheduled
2018-01-03 16:05jorge-garciaAssigned ToRetail => jorge-garcia
2018-01-08 08:49hgbotCheckin
2018-01-08 08:49hgbotNote Added: 0101606
2018-01-08 08:49hgbotStatusscheduled => resolved
2018-01-08 08:49hgbotResolutionopen => fixed
2018-01-08 08:49hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/3738b06a513d5c21546f65515d5b579b6dc3813e [^]
2018-02-06 18:24marvintmReview Assigned To => marvintm
2018-02-06 18:24marvintmStatusresolved => closed
2018-02-06 18:24marvintmFixed in Version => RR18Q2

Notes
(0101606)
hgbot   
2018-01-08 08:49   
Repository: erp/pmods/org.openbravo.mobile.core
Changeset: 3738b06a513d5c21546f65515d5b579b6dc3813e
Author: Jorge Garcia <jorge.garcia <at> openbravo.com>
Date: Fri Jan 05 10:58:17 2018 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.mobile.core/rev/3738b06a513d5c21546f65515d5b579b6dc3813e [^]

Fixed issue 37577: Performance issues in Web POS while working with big
amount of manual Discount (9.000)

The solution is to check if exists at least one manual discount in the database
and it’s not needed retrieve all promotions.

---
M web/org.openbravo.mobile.core/source/utils/ob-utilities.js
---