Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0048336Retail ModulesWeb POSpublic2021-12-29 11:202021-12-29 11:30
Reporterkchoperena 
Assigned ToRetail 
PriorityhighSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
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
Summary0048336: Create an index in the ccgsBarcode column of OBDICO_Digitalcoupons to improve ValidateChequeCadeauBarcode query performance
DescriptionThe ValidateChequeCadeauBarcode is running a query that has a bad performance. This process is executed in each digital coupon creation

In BUT, the query takes 613ms
Adding the index improves to 0.3ms
Steps To Reproduce1.- Log in to the WEBPOS
2.- Using the menu, create a digital coupon

EXPECTED RESULT:
When completing the digital coupon, the query is executed to validate if there is a cheque cadeau with the same barcode already created
Proposed SolutionSee the attached file
Additional Information
TagsNo tags attached.
Relationships
Attached Filesdiff patch_48336.diff (590) 2021-12-29 11:30
https://issues.openbravo.com/file_download.php?file_id=16478&type=bug
Issue History
Date ModifiedUsernameFieldChange
2021-12-29 11:20kchoperenaNew Issue
2021-12-29 11:20kchoperenaAssigned To => Retail
2021-12-29 11:20kchoperenaTriggers an Emergency Pack => No
2021-12-29 11:30kchoperenaFile Added: patch_48336.diff
2021-12-29 11:30kchoperenaProposed Solution updated

There are no notes attached to this issue.