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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0047423
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajoralways2021-07-21 12:002021-09-01 07:55
ReporteregoitzView Statuspublic 
Assigned Toranjith_qualiantech_com 
PrioritynormalResolutionfixedFixed in VersionRR21Q4
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0047423: Slow incremental refresh of products

DescriptionThe incremental refresh in environment with lots of products, and stores, and one assortment and pricelist per store, is very slow.
The query reads lot of information from disk and create also general slowness on the server.
Steps To Reproduce- Update 30.000 of prices of a catalog of 240.000 on an environment as explained in the Description.

Proposed SolutionInitial query:

select ...
from ...
where ...

AND (
                      product1_.updated>'2021-07-20 10:06:39.019'
           OR obretco_pr0_.updated>'2021-07-20 10:06:39.019'
           OR uom4_.updated>'2021-07-20 10:06:39.019'
           OR pricingpro2_.updated>'2021-07-20 10:06:39.019')
...

Proposed change:

select ...
from ...
where ...

AND product1_.m_product_id in (
    SELECT o.m_product_id
      FROM obretco_prol_product o
      WHERE o.updated > '2021-07-20 10:06:39.019'
        AND o.obretco_productlist_id='F5E7536B8CEA476D82AE0CF40555A426' --> to filter by the assortment of the store
    UNION
    SELECT p.m_product_id
      FROM m_productprice p
      WHERE p.updated > '2021-07-20 10:06:39.019'
        AND p.m_pricelist_version_id='49D82092B886446CAB1245A5227CE9C9' --> to filter by the price list of the store
    UNION
    SELECT mp.m_product_id
      FROM m_product mp
      INNER JOIN m_uom u
        ON u.m_uom_id = mp.m_uom_id
      WHERE u.updated > '2021-07-20 10:06:39.019'
    UNION
    SELECT pro.m_product_id
      FROM m_product pro
      WHERE pro.updated > '2021-07-20 10:06:39.019'
)
TagsNOR
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0044911 closedranjith_qualiantech_com Incremental refresh of Product cannot use index on updated 
related to defect 0047510 closedranjith_qualiantech_com in 21Q2, incremental refresh process is slower in 21Q2 than previous releases 
related to defect 0047262 closedranjith_qualiantech_com Incremental refresh not updating business partner product price 

-  Notes
(0131321)
hgbot (developer)
2021-08-24 13:44

 Merge request closed: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/535 [^]
(0131401)
hgbot (developer)
2021-08-27 11:38

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/555 [^]
(0131467)
hgbot (developer)
2021-09-01 07:55

 Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: c5ae003638440f56bbb46f56892060022d36be27
Author: Ranjith S R <ranjith@qualiantech.com>
Date: 2021-09-01T05:54:49+00:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/c5ae003638440f56bbb46f56892060022d36be27 [^]

Fixed ISSUE-47423: Added Preference to Load Product based on Product Price Changes
* Added Preference "WebPOS Product filter by Price"
* During incremental refresh, Product Price which are changed will be loaded
* Preference "WebPOS Product filter by Price" and "WebPOS Product filter by entities" should not set at same time

---
M src-db/database/sourcedata/AD_PREFERENCE.xml
M src-db/database/sourcedata/AD_REF_LIST.xml
M src/org/openbravo/retail/posterminal/master/Product.java
---
(0131468)
hgbot (developer)
2021-09-01 07:55

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/555 [^]

- Issue History
Date Modified Username Field Change
2021-07-21 12:00 egoitz New Issue
2021-07-21 12:00 egoitz Assigned To => Retail
2021-07-21 12:00 egoitz Resolution time => 1628546400
2021-07-21 12:00 egoitz Triggers an Emergency Pack => No
2021-07-21 22:30 rafaroda Tag Attached: NOR
2021-07-21 22:30 rafaroda Issue Monitored: rafaroda
2021-07-21 22:31 rafaroda Relationship added related to 0044911
2021-07-30 09:41 adrianromero Status new => acknowledged
2021-08-03 14:39 adrianromero Assigned To Retail => ranjith_qualiantech_com
2021-08-03 14:39 adrianromero Status acknowledged => scheduled
2021-08-04 14:31 hgbot Note Added: 0130974
2021-08-06 12:25 adrianromero Relationship added related to 0047510
2021-08-11 09:22 adrianromero Relationship added related to 0047262
2021-08-19 14:30 marvintm Resolution time 1628546400 => 1629842400
2021-08-24 13:44 marvintm Note Deleted: 0130974
2021-08-24 13:44 hgbot Note Added: 0131321
2021-08-27 07:22 marvintm Resolution time 1629842400 => 1630620000
2021-08-27 11:38 hgbot Note Added: 0131401
2021-09-01 07:55 hgbot Resolution open => fixed
2021-09-01 07:55 hgbot Status scheduled => closed
2021-09-01 07:55 hgbot Fixed in Version => RR21Q4
2021-09-01 07:55 hgbot Note Added: 0131467
2021-09-01 07:55 hgbot Note Added: 0131468

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker