Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0035217

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

defect

[Retail Modules] Web POS

major

always

2017-02-10 09:29

2017-02-20 11:51

Reporter

aaroncalero

View Status

public

Assigned To

ranjith_qualiantech_com

Priority

normal

Resolution

fixed

Fixed in Version

RR17Q2

Status

closed

Fix in branch

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Any

Database

Any

Java version

OS Version

Database version

Ant version

Product Version

SCM revision

Review Assigned To

marvintm

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0035217: There is no index by m_product_category_id in the obretco_productcategory table

Description

The table obretco_productcategory, which holds the product categories used by each of the assortments, does not have an index by its m_product_category_id column.

If the obretco_productcategory table has lots of records (e.g. 300 assortments with 1500 categories on each of them), one of the queries to retrieve product categories takes up to 9 seconds.

Steps To Reproduce

-

Proposed Solution

Attached diff with the missing index

Tags

No tags attached.

Issue35217.diff [^] (741 bytes) 2017-02-10 10:04 [Show Content] [Hide Content]

diff --git a/src-db/database/model/tables/OBRETCO_PRODUCTCATEGORY.xml b/src-db/database/model/tables/OBRETCO_PRODUCTCATEGORY.xml
--- a/src-db/database/model/tables/OBRETCO_PRODUCTCATEGORY.xml
+++ b/src-db/database/model/tables/OBRETCO_PRODUCTCATEGORY.xml
@@ -53,6 +53,9 @@
       <foreign-key foreignTable="OBRETCO_PRODUCTLIST" name="OBRETCO_PRODUCTCATEGORY_PL">
         <reference local="OBRETCO_PRODUCTLIST_ID" foreign="OBRETCO_PRODUCTLIST_ID"/>
       </foreign-key>
+      <index name="OBRETCO_PRCAT_PROD_CAT_IDX" unique="false">
+        <index-column name="M_PRODUCT_CATEGORY_ID"/>
+      </index>
       <index name="OBRETCO_PRCAT_PROD_LIST_IDX" unique="false">
         <index-column name="OBRETCO_PRODUCTLIST_ID"/>
       </index>

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
(0094432) hgbot (developer) 2017-02-17 07:42	Repository: erp/pmods/org.openbravo.retail.config Changeset: 0e920917f139b032b8e082f710b2d0b9adb0446a Author: Ranjith S R <ranjith <at> qualiantech.com> Date: Fri Feb 17 12:12:23 2017 +0530 URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.config/rev/0e920917f139b032b8e082f710b2d0b9adb0446a [^] Fixed issue 35217 : Added index for Assortment Product Category Table --- M src-db/database/model/tables/OBRETCO_PRODUCTCATEGORY.xml ---

Issue History
Date Modified	Username	Field	Change
2017-02-10 09:29	aaroncalero	New Issue
2017-02-10 09:29	aaroncalero	Assigned To	=> Retail
2017-02-10 09:29	aaroncalero	Triggers an Emergency Pack	=> No
2017-02-10 10:03	aaroncalero	Resolution time	=> 1487890800
2017-02-10 10:04	aaroncalero	File Added: Issue35217.diff
2017-02-10 10:04	aaroncalero	Proposed Solution updated
2017-02-13 09:35	ranjith_qualiantech_com	Assigned To	Retail => ranjith_qualiantech_com
2017-02-13 09:35	ranjith_qualiantech_com	Status	new => scheduled
2017-02-17 07:42	hgbot	Checkin
2017-02-17 07:42	hgbot	Note Added: 0094432
2017-02-17 07:42	hgbot	Status	scheduled => resolved
2017-02-17 07:42	hgbot	Resolution	open => fixed
2017-02-17 07:42	hgbot	Fixed in SCM revision	=> http://code.openbravo.com/erp/pmods/org.openbravo.retail.config/rev/0e920917f139b032b8e082f710b2d0b9adb0446a [^]
2017-02-20 11:51	marvintm	Review Assigned To	=> marvintm
2017-02-20 11:51	marvintm	Status	resolved => closed
2017-02-20 11:51	marvintm	Fixed in Version	=> RR17Q2

Copyright © 2000 - 2009 MantisBT Group