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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0040514
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2019-04-03 18:252019-04-23 18:03
ReporteraaroncaleroView Statuspublic 
Assigned Torqueralta 
PriorityhighResolutionfixedFixed in VersionRR19Q3
StatusclosedFix in branchFixed in SCM revision15741c9298d5
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned Toadrianromero
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0040514: [Complementary Products] Missing indexes by m_complementary_product_id in database and websql

DescriptionThe table OBRECP_ComplementaryProduct is missing an index on the column M_Product_Complementary_ID.
In a customer environment with ~100000 complementary products and a Master Data Batch size of 60000 (two paged requests for the same model) the query time improves by a 35% (from 1.7 seconds to 1.1 seconds) by adding this index.

Additionally, the same index should be added also to the javascript/websql part. In the customer environment, showing complementary products without the index was taking several minutes, whereas it was taking only a few milliseconds after adding the index.
Steps To ReproduceIn a customer environment with a high amount of complementary products (50K+), do the full refresh login in web pos and compare the times of the ComplementaryProducts model before and after adding the index.

For the websql part, in the same environment, create a ticket and add a product with complementary products. Click on the complementary products button and compare times before and after adding the index.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0111031)
hgbot (developer)
2019-04-08 22:13

 Repository: erp/pmods/org.openbravo.retail.complementary
Changeset: 15741c9298d57c0c93194c8271517c1fec272ec7
Author: Rafael Queralta <rafaelcuba81 <at> gmail.com>
Date: Mon Apr 08 15:00:34 2019 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.complementary/rev/15741c9298d57c0c93194c8271517c1fec272ec7 [^]

Fixed issue 40514: [Complementary Products] Missing indexes by
m_complementary_product_id in database and websql

- Added new index in database and websql for M_Product_Complementary_ID column.

---
M src-db/database/model/tables/OBRECP_COMPLEMENTARYPRODUCT.xml
M web/org.openbravo.retail.complementary/js/modelComplementaryProduct.js
---
(0111245)
adrianromero (manager)
2019-04-23 18:03

 Verified

- Issue History
Date Modified Username Field Change
2019-04-03 18:25 aaroncalero New Issue
2019-04-03 18:25 aaroncalero Assigned To => Retail
2019-04-03 18:25 aaroncalero Resolution time => 1555452000
2019-04-03 18:25 aaroncalero Triggers an Emergency Pack => No
2019-04-04 15:08 rqueralta Assigned To Retail => rqueralta
2019-04-04 15:08 rqueralta Status new => scheduled
2019-04-08 22:13 hgbot Checkin
2019-04-08 22:13 hgbot Note Added: 0111031
2019-04-08 22:13 hgbot Status scheduled => resolved
2019-04-08 22:13 hgbot Resolution open => fixed
2019-04-08 22:13 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.complementary/rev/15741c9298d57c0c93194c8271517c1fec272ec7 [^]
2019-04-23 18:03 adrianromero Review Assigned To => adrianromero
2019-04-23 18:03 adrianromero Note Added: 0111245
2019-04-23 18:03 adrianromero Status resolved => closed
2019-04-23 18:03 adrianromero Fixed in Version => RR19Q3

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker