Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022588Retail ModulesWeb POSpublic2012-12-14 14:202012-12-21 13:09
Reporterguilleaer 
Assigned Toguilleaer 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionRMP18Fixed in VersionRMP18 
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
Summary0022588: 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
has duplicate design defect 0021157RMP18 closed guilleaer Doc num calculation will not scale 
Attached Filesdiff diffComputeDocNo.diff (4,589) 2012-12-14 14:24
https://issues.openbravo.com/file_download.php?file_id=5841&type=bug
Issue History
Date ModifiedUsernameFieldChange
2012-12-14 14:20guilleaerNew Issue
2012-12-14 14:20guilleaerAssigned To => guilleaer
2012-12-14 14:24guilleaerFile Added: diffComputeDocNo.diff
2012-12-14 14:32guilleaerNote Added: 0054951
2012-12-18 08:50hgbotCheckin
2012-12-18 08:50hgbotNote Added: 0055030
2012-12-18 08:50hgbotStatusnew => resolved
2012-12-18 08:50hgbotResolutionopen => fixed
2012-12-18 08:50hgbotFixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/5aea68ec10928d51547e7fe24f064629a79300e6 [^]
2012-12-21 13:09marvintmStatusresolved => closed
2012-12-21 13:09marvintmFixed in Version => RMP18
2012-12-21 13:52guilleaerRelationship addedblocks 0021157
2012-12-21 13:55guilleaerRelationship replacedhas duplicate 0021157

Notes
(0054951)
guilleaer   
2012-12-14 14:32   
Note about the provided patch:
+ rs.close();
+ ps.close();

move these lines to finally
(0055030)
hgbot   
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
---