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 ]
|
|
 Relationships |
|
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 [^] |
|
Notes |
|
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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |