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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0043390
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Layaway ordermajorhave not tried2020-03-02 17:512020-03-12 13:14
ReporterALopeteguiView Statuspublic 
Assigned Torqueralta 
PriorityhighResolutionfixedFixed in VersionRR20Q2
StatusclosedFix in branchFixed in SCM revisionf6e7f2427735
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned Tomarvintm
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0043390: Void Layaway BGProcess bad performance

DescriptionAutomatic void of layaway BGProcess has bad performance query getting the layaway List.
Steps To ReproduceIn high volume environment run "Automatic void of layaway" BGProcess.

Here the query explain plan
https://explain.depesz.com/s/FJ8b [^]
Proposed SolutionThe launched query needs to be filtered also for ad_client_id in order to perform correctly the core index c_order_client_org_date_docno.

In the past there was a custom index of symmetric DS, only ad_org_id in c_order, but after symmetricDS unistall, the core index doesn't work properly if we dont' filter by ad_client_id.

Attached diff to filter also by ad_client_id, doing a subselect to get the id:

Here the new explain plan:
https://explain.depesz.com/s/3ybN [^]
TagsNo tags attached.
Attached Filesdiff file icon VoidLayawaysBGProcess.diff [^] (899 bytes) 2020-03-02 17:51 [Show Content]

- Relationships [ Relation Graph ] [ Dependency Graph ]

-  Notes
(0118432)
hgbot (developer)
2020-03-09 22:03

 Repository: erp/pmods/org.openbravo.retail.autocancelreservation
Changeset: f6e7f24277354ad196efc79fa0eb903ef658e023
Author: Rafael Queralta <rafaelcuba81 <at> gmail.com>
Date: Mon Mar 09 17:02:59 2020 -0400
URL: http://code.openbravo.com/erp/pmods/org.openbravo.retail.autocancelreservation/rev/f6e7f24277354ad196efc79fa0eb903ef658e023 [^]

Fixed BUG-43390: Void Layaway BGProcess bad performance

- Filter by ad_client_id, doing a subselect to get the id

---
M src/org/openbravo/retail/autocancelreservation/process/VoidLayawaysBGProcess.java
---

- Issue History
Date Modified Username Field Change
2020-03-02 17:51 ALopetegui New Issue
2020-03-02 17:51 ALopetegui Assigned To => Retail
2020-03-02 17:51 ALopetegui File Added: VoidLayawaysBGProcess.diff
2020-03-02 17:51 ALopetegui Resolution time => 1581807600
2020-03-02 17:51 ALopetegui Triggers an Emergency Pack => No
2020-03-04 19:09 marvintm Resolution time 1581807600 => 1585004400
2020-03-09 16:30 rqueralta Assigned To Retail => rqueralta
2020-03-09 16:30 rqueralta Status new => scheduled
2020-03-09 22:03 hgbot Checkin
2020-03-09 22:03 hgbot Note Added: 0118432
2020-03-09 22:03 hgbot Status scheduled => resolved
2020-03-09 22:03 hgbot Resolution open => fixed
2020-03-09 22:03 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/pmods/org.openbravo.retail.autocancelreservation/rev/f6e7f24277354ad196efc79fa0eb903ef658e023 [^]
2020-03-12 12:46 ALopetegui Issue Monitored: ALopetegui
2020-03-12 13:14 marvintm Review Assigned To => marvintm
2020-03-12 13:14 marvintm Status resolved => closed
2020-03-12 13:14 marvintm Fixed in Version => RR20Q2

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker