Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0051609 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 09. Financial management | major | always | 2023-02-15 12:34 | 2023-03-01 14:06 | |||
Reporter | malsasua | View Status | public | |||||
Assigned To | francisco_ofarril | |||||||
Priority | high | Resolution | fixed | Fixed in Version | ||||
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 | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0051609: SAFT query is slow | |||||||
Description | There is a query that it is slow, and it is causing performance problems: select count(*) as y0_ from C_Invoice this_ where (this_.EM_Saft_Documentno=$1 or this_.DocumentNo=$2) and this_.C_Invoice_ID<>$3 and this_.AD_Org_ID in (... In a customer with big data, it takes a round 15 seconds, but in some case, it taken more than 10min: 2023-02-14 14:43:59 duration: 14342.852 2023-02-14 14:53:05 duration: 13232.944 2023-02-14 15:13:23 duration: 13298.924 2023-02-14 15:23:07 duration: 14113.248 2023-02-14 15:44:09 duration: 667097.163 2023-02-14 15:45:01 duration: 28241.670 In internal note, I will inform where is executed the query | |||||||
Steps To Reproduce | n/a | |||||||
Proposed Solution | add index by column EM_Saft_Documentno in Invoice and Order tables | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | |
Notes | |
(0146613) psanjuan (manager) 2023-02-16 09:30 |
https://openbravo.atlassian.net/browse/RM-5132 [^] |
(0147074) hgbot (developer) 2023-02-27 20:26 |
Merge Request created: https://gitlab.com/openbravo/product/pmods/com.practicsbs.saftpt/-/merge_requests/44 [^] |
(0147176) hgbot (developer) 2023-03-01 14:06 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/openbravo/product/pmods/com.practicsbs.saftpt [^] Changeset: efb03d6a1c03830bd528daafb2839240e4fc1eff Author: Francisco Javier Deler O'Farril <francisco.ofarril@openbravo.com> Date: 01-03-2023 13:06:34 URL: https://gitlab.com/openbravo/product/pmods/com.practicsbs.saftpt/-/commit/efb03d6a1c03830bd528daafb2839240e4fc1eff [^] Fixes ISSUE-51609: SAFT query is slow --- M src-db/database/model/modifiedTables/C_INVOICE.xml M src-db/database/model/modifiedTables/C_ORDER.xml --- |
(0147177) hgbot (developer) 2023-03-01 14:06 |
Merge request merged: https://gitlab.com/openbravo/product/pmods/com.practicsbs.saftpt/-/merge_requests/44 [^] |
Issue History | |||
Date Modified | Username | Field | Change |
2023-02-15 12:34 | malsasua | New Issue | |
2023-02-15 12:34 | malsasua | Assigned To | => Triage Omni OMS |
2023-02-15 12:34 | malsasua | Modules | => Core |
2023-02-15 12:34 | malsasua | Triggers an Emergency Pack | => No |
2023-02-15 12:35 | malsasua | Proposed Solution updated | |
2023-02-15 19:41 | aferraz | Assigned To | Triage Omni OMS => francisco_ofarril |
2023-02-16 09:30 | psanjuan | Note Added: 0146613 | |
2023-02-27 20:26 | hgbot | Note Added: 0147074 | |
2023-02-27 20:39 | francisco_ofarril | Status | new => acknowledged |
2023-02-28 18:07 | francisco_ofarril | Status | acknowledged => scheduled |
2023-03-01 14:06 | hgbot | Resolution | open => fixed |
2023-03-01 14:06 | hgbot | Status | scheduled => closed |
2023-03-01 14:06 | hgbot | Note Added: 0147176 | |
2023-03-01 14:06 | hgbot | Note Added: 0147177 |
Copyright © 2000 - 2009 MantisBT Group |