Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0037534Retail ModulesWeb POSpublic2017-12-21 09:202018-03-06 18:58
Reporterumartirena 
Assigned Toranjith_qualiantech_com 
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
Summary0037534: Brand query in local database takes long and Web POS sometimes crashes
DescriptionBrand query in local database takes long and Web POS sometimes crashes.
Steps To ReproduceThe issue is reproduced having 40.000 product records and 1.200 brand records, both in local database
Proposed SolutionAdd index by brand in m_product Web POS local database table
Additional Information
TagsPerformance
Relationships
Attached Filesdiff bug37534.diff (1,057) 2018-02-08 18:49
https://issues.openbravo.com/file_download.php?file_id=11560&type=bug
Issue History
Date ModifiedUsernameFieldChange
2017-12-21 09:20umartirenaNew Issue
2017-12-21 09:20umartirenaAssigned To => Retail
2017-12-21 09:20umartirenaTriggers an Emergency Pack => No
2018-01-03 15:21SandrahuguetTag Attached: Performance
2018-02-08 13:27egoitzResolution time => 1519254000
2018-02-08 18:49egoitzFile Added: bug37534.diff
2018-02-08 18:49egoitzNote Added: 0102278
2018-02-08 18:49egoitzIssue Monitored: egoitz
2018-02-28 14:34ranjith_qualiantech_comAssigned ToRetail => ranjith_qualiantech_com
2018-02-28 14:34ranjith_qualiantech_comStatusnew => scheduled
2018-03-01 06:59hgbotCheckin
2018-03-01 06:59hgbotNote Added: 0102889
2018-03-01 06:59hgbotStatusscheduled => resolved
2018-03-01 06:59hgbotResolutionopen => fixed
2018-03-01 06:59hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/90614355c75df40da99a3a194c022dacefad177c [^]
2018-03-06 18:58marvintmReview Assigned To => marvintm
2018-03-06 18:58marvintmStatusresolved => closed
2018-03-06 18:58marvintmFixed in Version => RR18Q2

Notes
(0102278)
egoitz   
2018-02-08 18:49   
Patch attached to create the index of the proposal solution and another index that is also needed
(0102889)
hgbot   
2018-03-01 06:59   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 90614355c75df40da99a3a194c022dacefad177c
Author: Ranjith S R <ranjith <at> qualiantech.com>
Date: Thu Mar 01 11:28:56 2018 +0530
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/90614355c75df40da99a3a194c022dacefad177c [^]

Fixed issue 37534 : Added index to Product and Brand table

---
M web/org.openbravo.retail.posterminal/js/model/brand.js
M web/org.openbravo.retail.posterminal/js/model/product.js
---