Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022942Retail ModulesWeb POSpublic2013-01-31 13:272017-02-14 15:47
Reportermarvintm 
Assigned Tomarvintm 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionno change required 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022942: The way to compute the next document sequence may have performance problems, and should be changed
DescriptionCurrently the way to compute the next document sequence is to query the database for the existing orders, and find the maximum document number. This will be very costly in performance for customers with even a moderate amount of orders.

Therefore, a new way to get the next sequence should be found.
Steps To ReproduceLog in the Web POS in an environment with a sufficiently large number of orders.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0022652 new adrianromero Web POS documentno starting sequence 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-01-31 13:27marvintmNew Issue
2013-01-31 13:27marvintmAssigned To => marvintm
2013-01-31 13:27marvintmOBNetwork customer => No
2013-02-06 10:35migueldejuanaTarget Version => RMP20
2013-02-06 10:38migueldejuanaRelationship addedrelated to 0022652
2013-02-28 08:10marvintmTarget VersionRMP20 => RMP21
2013-03-06 18:04migueldejuanaTypedefect => design defect
2013-03-22 10:13marvintmTarget VersionRMP21 =>
2017-02-14 15:47marvintmStatusnew => closed
2017-02-14 15:47marvintmResolutionopen => no change required

There are no notes attached to this issue.