0048336: Create an index in the ccgsBarcode column of OBDICO_Digitalcoupons to improve ValidateChequeCadeauBarcode query performance

Description

The 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 Reproduce

1.- 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 Solution

See the attached file

Tags

No tags attached.

Attached Files

patch_48336.diff [^] (590 bytes) 2021-12-29 11:30 [Show Content] [Hide Content]

diff --git a/src-db/database/model/modifiedTables/OBDICO_DIGITALCOUPONS.xml b/src-db/database/model/modifiedTables/OBDICO_DIGITALCOUPONS.xml
index 0d6c6d7..cb56afc 100644
--- a/src-db/database/model/modifiedTables/OBDICO_DIGITALCOUPONS.xml
+++ b/src-db/database/model/modifiedTables/OBDICO_DIGITALCOUPONS.xml
@@ -9,5 +9,8 @@
         <default><![CDATA[Y]]></default>
         <onCreateDefault><![CDATA['Y']]></onCreateDefault>
       </column>
+      <index name="EM_CCGS_BARCODE" unique="false">
+        <index-column name="EM_CCGS_BARCODE"/>
+      </index>
     </table>
   </database>

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2021-12-29 11:20	kchoperena	New Issue
2021-12-29 11:20	kchoperena	Assigned To	=> Retail
2021-12-29 11:20	kchoperena	Triggers an Emergency Pack	=> No
2021-12-29 11:30	kchoperena	File Added: patch_48336.diff
2021-12-29 11:30	kchoperena	Proposed Solution updated