Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0021157Retail ModulesWeb POSpublic2012-07-19 15:482012-12-21 13:55
Reporteralostale 
Assigned Toguilleaer 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionduplicate 
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
Summary0021157: Doc num calculation will not scale
DescriptionWhenever POS application is loaded, next doc number needs to be calculated.

Currently, this is done iterating over all orders generated from the terminal to get the maximum number. This won't scale if the number of orders is big enough. Also the query is using a like doc num, so index cannot be used.
Steps To Reproduce-
Proposed Solution
Additional Information
TagsPerformance
Relationships
duplicate of design defect 0022588RMP18 closed guilleaer Bad performance for big volumes when the next document number for orders and quotations is calculated. 
related to defect 0021154 closed AugustoMauch Duplicated order document numbers 
related to feature request 0021194 new adrianromero Availability of restarting Web POS sequences 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2012-07-19 15:48alostaleNew Issue
2012-07-19 15:48alostaleAssigned To => adrianromero
2012-07-19 15:49alostaleRelationship addedrelated to 0021156
2012-07-19 15:49alostaleRelationship addedrelated to 0021154
2012-07-19 15:49alostaleRelationship deletedrelated to 0021156
2012-07-19 15:53alostaleTag Attached: Performance
2012-07-19 16:26hgbotCheckin
2012-07-19 16:26hgbotNote Added: 0050764
2012-07-25 10:40adrianromeroRelationship addedrelated to 0021194
2012-11-09 11:31adrianromeroStatusnew => scheduled
2012-11-09 11:31adrianromerofix_in_branch => pi
2012-12-20 14:24adrianromeroAssigned Toadrianromero => guilleaer
2012-12-20 14:25adrianromeroTarget Version => RMP18
2012-12-20 14:25adrianromerofix_in_branchpi =>
2012-12-21 13:52guilleaerRelationship addeddepends on 0022588
2012-12-21 13:55guilleaerRelationship replacedduplicate of 0022588
2012-12-21 13:55guilleaerNote Added: 0055157
2012-12-21 13:55guilleaerStatusscheduled => closed
2012-12-21 13:55guilleaerResolutionopen => duplicate
2012-12-21 13:55guilleaerFixed in Version => RMP18

Notes
(0050764)
hgbot   
2012-07-19 16:26   
Repository: erp/pmods/org.openbravo.retail.posterminal
Changeset: 80406dfbc2754a6da3aa9c2e1fc6cc0b6549f10c
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Thu Jul 19 16:25:38 2012 +0200
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.posterminal/rev/80406dfbc2754a6da3aa9c2e1fc6cc0b6549f10c [^]

Related to issue 21157: Perfomance improvements in sequence number initialization

Changes:
- Using ScrollableResults instead of list()
- Retrieving the orders or a POS terminal filtering by em_obpos_applications_id instead of using a like query against the document number column.

---
M src/org/openbravo/retail/posterminal/POSUtils.java
M src/org/openbravo/retail/posterminal/term/Terminal.java
---
(0055157)
guilleaer   
2012-12-21 13:55   
fixed: https://issues.openbravo.com/view.php?id=22588 [^]