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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0037078
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2017-10-16 18:112017-10-24 09:59
ReporteregoitzView Statuspublic 
Assigned Tomarvintm 
PriorityurgentResolutionfixedFixed in VersionRR18Q1
StatusclosedFix in branchFixed in SCM revision1492bc7ad416
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toguilleaer
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0037078: C_get_product_taxcategory affects to the performance of the load of product masterdata

DescriptionWith high volumes the c_get_product_taxcagetory functions affects to the performance of the query to get the product masterdata.
Removing that function reduces a lot the query execution time.
Steps To Reproduce-Execute the full refresh on a product with high volumes.

Proposed Solution-Check the preference on the java and if an alternative way to get the tax has not been implemented, don't use the function.
TagsPerformance
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0038231 closedranjith_qualiantech_com Product Master Data Loading is very slow having configured org.openbravo.financial.multitaxcategory module 

-  Notes
(0099951)
hgbot (developer)
2017-10-19 09:00

Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 1492bc7ad416a2b745280c6ac9731ba3097be253
Author: Antonio Moreno <antonio.moreno <at> openbravo.com>
Date: Wed Oct 18 18:27:31 2017 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1492bc7ad416a2b745280c6ac9731ba3097be253 [^]

Fixed issue 37078. c_get_product_taxcategory function will only be called if preference is set.

---
M src/org/openbravo/retail/posterminal/master/ProductProperties.java
---

- Issue History
Date Modified Username Field Change
2017-10-16 18:11 egoitz New Issue
2017-10-16 18:11 egoitz Assigned To => Retail
2017-10-16 18:11 egoitz Resolution time => 1505858400
2017-10-16 18:11 egoitz Triggers an Emergency Pack => No
2017-10-16 18:11 egoitz Issue Monitored: malsasua
2017-10-16 18:21 egoitz Resolution time 1505858400 => 1508450400
2017-10-17 09:26 guillermogil Tag Attached: Performance
2017-10-18 18:39 marvintm Assigned To Retail => marvintm
2017-10-18 18:39 marvintm Status new => scheduled
2017-10-19 09:00 hgbot Checkin
2017-10-19 09:00 hgbot Note Added: 0099951
2017-10-19 09:00 hgbot Status scheduled => resolved
2017-10-19 09:00 hgbot Resolution open => fixed
2017-10-19 09:00 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/1492bc7ad416a2b745280c6ac9731ba3097be253 [^]
2017-10-24 09:59 guilleaer Review Assigned To => guilleaer
2017-10-24 09:59 guilleaer Status resolved => closed
2017-10-24 09:59 guilleaer Fixed in Version => RR18Q1
2018-03-26 19:30 umartirena Relationship added related to 0038231


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker