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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0022588
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Retail Modules] Web POSminoralways2012-12-14 14:202012-12-21 13:09
ReporterguilleaerView Statuspublic 
Assigned Toguilleaer 
PrioritynormalResolutionfixedFixed in VersionRMP18
StatusclosedFix in branchFixed in SCM revision5aea68ec1092
ProjectionnoneETAnoneTarget VersionRMP18
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0022588: Bad performance for big volumes when the next document number for orders and quotations is calculated.

DescriptionBad performance for big volumes when the next document number for orders and quotations is calculated.
Steps To ReproduceWhen Web POS is being initialized the last document number is searched. if there are many orders this process is very slow.
TagsNo tags attached.
Attached Filesdiff file icon diffComputeDocNo.diff [^] (4,589 bytes) 2012-12-14 14:24 [Show Content]

- Relationships Relation Graph ] Dependency Graph ]
has duplicate design defect 0021157RMP18 closedguilleaer Doc num calculation will not scale 

-  Notes
(0054951)
guilleaer (manager)
2012-12-14 14:32

Note about the provided patch:
+ rs.close();
+ ps.close();

move these lines to finally
(0055030)
hgbot (developer)
2012-12-18 08:50

Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 5aea68ec10928d51547e7fe24f064629a79300e6
Author: Guillermo Alvarez de Eulate <guillermo.alvarez <at> openbravo.com>
Date: Tue Dec 18 08:48:26 2012 +0100
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5aea68ec10928d51547e7fe24f064629a79300e6 [^]

fixed issue 22588: The way to calculate the last document no has been changed improving the performance specially with big volume of data

---
M src/org/openbravo/retail/posterminal/POSUtils.java
---

- Issue History
Date Modified Username Field Change
2012-12-14 14:20 guilleaer New Issue
2012-12-14 14:20 guilleaer Assigned To => guilleaer
2012-12-14 14:24 guilleaer File Added: diffComputeDocNo.diff
2012-12-14 14:32 guilleaer Note Added: 0054951
2012-12-18 08:50 hgbot Checkin
2012-12-18 08:50 hgbot Note Added: 0055030
2012-12-18 08:50 hgbot Status new => resolved
2012-12-18 08:50 hgbot Resolution open => fixed
2012-12-18 08:50 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5aea68ec10928d51547e7fe24f064629a79300e6 [^]
2012-12-21 13:09 marvintm Status resolved => closed
2012-12-21 13:09 marvintm Fixed in Version => RMP18
2012-12-21 13:52 guilleaer Relationship added blocks 0021157
2012-12-21 13:55 guilleaer Relationship replaced has duplicate 0021157


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker