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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0021157
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Retail Modules] Web POSmajorhave not tried2012-07-19 15:482012-12-21 13:55
ReporteralostaleView Statuspublic 
Assigned Toguilleaer 
PrioritynormalResolutionduplicateFixed in VersionRMP18
StatusclosedFix in branchFixed in SCM revision
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

0021157: 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-
TagsPerformance
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
duplicate of design defect 0022588RMP18 closedguilleaer Bad performance for big volumes when the next document number for orders and quotations is calculated. 
related to defect 0021154 closedAugustoMauch Duplicated order document numbers 
related to feature request 0021194 newadrianromero Availability of restarting Web POS sequences 

-  Notes
(0050764)
hgbot (developer)
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 (manager)
2012-12-21 13:55

fixed: https://issues.openbravo.com/view.php?id=22588 [^]

- Issue History
Date Modified Username Field Change
2012-07-19 15:48 alostale New Issue
2012-07-19 15:48 alostale Assigned To => adrianromero
2012-07-19 15:49 alostale Relationship added related to 0021156
2012-07-19 15:49 alostale Relationship added related to 0021154
2012-07-19 15:49 alostale Relationship deleted related to 0021156
2012-07-19 15:53 alostale Tag Attached: Performance
2012-07-19 16:26 hgbot Checkin
2012-07-19 16:26 hgbot Note Added: 0050764
2012-07-25 10:40 adrianromero Relationship added related to 0021194
2012-11-09 11:31 adrianromero Status new => scheduled
2012-11-09 11:31 adrianromero fix_in_branch => pi
2012-12-20 14:24 adrianromero Assigned To adrianromero => guilleaer
2012-12-20 14:25 adrianromero Target Version => RMP18
2012-12-20 14:25 adrianromero fix_in_branch pi =>
2012-12-21 13:52 guilleaer Relationship added depends on 0022588
2012-12-21 13:55 guilleaer Relationship replaced duplicate of 0022588
2012-12-21 13:55 guilleaer Note Added: 0055157
2012-12-21 13:55 guilleaer Status scheduled => closed
2012-12-21 13:55 guilleaer Resolution open => duplicate
2012-12-21 13:55 guilleaer Fixed in Version => RMP18


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker