Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0058073 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [POS2] Fashion | major | always | 2025-02-25 14:23 | 2025-03-11 11:05 | |||
| Reporter | sofidossant | View Status | public | |||||
| Assigned To | caristu | |||||||
| 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 | pi | SCM revision | ||||||
| Merge Request Status | approved | |||||||
| Review Assigned To | alostale | |||||||
| OBNetwork customer | OBPS | |||||||
| Support ticket | 122020 | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0058073: Performance: Slowness loading the Product window using the Openbravo Retail fashion module | |||||||
| Description | Getting results on the grid of the Product window takes long having thousands of Products and when using the REtail fashion module, and showing the 3 property filed related to color, size and season. Analyzing the query executed by the grid it is fast (few ms) but the grid takes long to show. By debugging the code, we can see that a lot of queries are done after the query is finished to show information on the grid. The query is the following: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo/-/blob/master/modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/reference/materialmgmt/RelevantCharacteristicAdditionalPropertyResolver.java#L81 [^] There are 1632677 rows in ad_tree_node, and the query tools 300ms to finish, and the query is executed for all the results of the grid, so it takes longer to finish and show the data. | |||||||
| Steps To Reproduce | - On an environment with the retails fashion installed and a big number of records in the ad_treenode table - Have characteristics and show the color, size and season table - Open the product window It takes seconds to show the data | |||||||
| Proposed Solution | CREATE INDEX IF NOT EXISTS ad_treenode_nodeid ON public.ad_treenode USING btree (node_id COLLATE pg_catalog."default" ASC NULLS LAST) TABLESPACE pg_default; | |||||||
| Tags | Performance | |||||||
| Attached Files |  sqlformatter.sql [^] (8,964 bytes) 2025-02-25 17:41 | |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
|
(0176517) hgbot (developer) 2025-03-06 09:56 |
Merge Request created: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo/-/merge_requests/1572 [^] |
|
(0176622) hgbot (developer) 2025-03-10 16:11 |
Merge request merged: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo/-/merge_requests/1572 [^] |
|
(0176623) hgbot (developer) 2025-03-10 16:11 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo [^] Changeset: 06aec5a6d2dc98c75bc71393890bc42c255357a5 Author: Carlos Aristu <c.aristu@orisha.com> Date: 10-03-2025 15:08:44 URL: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo/-/commit/06aec5a6d2dc98c75bc71393890bc42c255357a5 [^] fixes BUG-58073: slow calc of prod char fields with many records in ad_trenode --- M src-db/database/model/tables/AD_TREENODE.xml --- |
|
(0176626) hgbot (developer) 2025-03-10 17:09 |
Merge Request created: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo/-/merge_requests/1576 [^] |
|
(0176648) hgbot (developer) 2025-03-11 10:36 |
Merge request merged: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo/-/merge_requests/1576 [^] |
|
(0176649) hgbot (developer) 2025-03-11 10:36 |
Directly closing issue as related merge request is already approved. Repository: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo [^] Changeset: 6ec50b04d6d12ae4d8af2209c892aaa8ad949bb7 Author: Carlos Aristu <c.aristu@orisha.com> Date: 11-03-2025 09:36:32 URL: https://gitlab.com/orisha-group/bu-commerce/openbravo/product/openbravo/-/commit/6ec50b04d6d12ae4d8af2209c892aaa8ad949bb7 [^] fixes BUG-58073: slow calc of prod char fields with many records in ad_trenode By modifying the existing query to filter by AD_TREE_ID also, an index scan is done using the existing `AD_TREENODE_TREE_NODE_UN` unique constraint. With this fix we can avoid the creation of the index only by node_id that we did to fix originally the issue. So we are removing that index with this changeset also. --- M modules/org.openbravo.client.kernel/src/org/openbravo/client/kernel/reference/materialmgmt/RelevantCharacteristicAdditionalPropertyResolver.java M src-db/database/model/tables/AD_TREENODE.xml --- |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2025-02-25 14:23 | sofidossant | New Issue | |
| 2025-02-25 14:23 | sofidossant | Assigned To | => Retail |
| 2025-02-25 14:23 | sofidossant | OBNetwork customer | => OBPS |
| 2025-02-25 14:23 | sofidossant | Support ticket | => 122020 |
| 2025-02-25 14:23 | sofidossant | Triggers an Emergency Pack | => No |
| 2025-02-25 14:32 | Practics | Issue Monitored: Practics | |
| 2025-02-25 15:08 | aaroncalero | Note Added: 0176115 | |
| 2025-02-25 15:08 | aaroncalero | Assigned To | Retail => sofidossant |
| 2025-02-25 15:08 | aaroncalero | Status | new => feedback |
| 2025-02-25 16:22 | sofidossant | Note Added: 0176124 | |
| 2025-02-25 16:22 | sofidossant | Status | feedback => new |
| 2025-02-25 16:56 | aaroncalero | Note Added: 0176128 | |
| 2025-02-25 16:56 | aaroncalero | Status | new => feedback |
| 2025-02-25 17:41 | sofidossant | Note Added: 0176130 | |
| 2025-02-25 17:41 | sofidossant | File Added: sqlformatter.sql | |
| 2025-02-25 17:42 | sofidossant | Status | feedback => new |
| 2025-02-26 11:12 | sofidossant | Note Added: 0176145 | |
| 2025-03-03 14:05 | egoitz | Assigned To | sofidossant => aaroncalero |
| 2025-03-04 16:29 | aaroncalero | Note Added: 0176446 | |
| 2025-03-04 16:29 | aaroncalero | Status | new => closed |
| 2025-03-04 16:29 | aaroncalero | Resolution | open => no change required |
| 2025-03-06 09:14 | egoitz | Summary | PERFORMANCE with the module Retail Fashion => Performance: Slowness loading the Product window using the Openbravo Retail fashion module |
| 2025-03-06 09:14 | egoitz | Description Updated | View Revisions |
| 2025-03-06 09:14 | egoitz | Steps to Reproduce Updated | View Revisions |
| 2025-03-06 09:14 | egoitz | Proposed Solution updated | |
| 2025-03-06 09:14 | egoitz | Assigned To | aaroncalero => caristu |
| 2025-03-06 09:14 | egoitz | Status | closed => new |
| 2025-03-06 09:14 | egoitz | Resolution | no change required => open |
| 2025-03-06 09:14 | egoitz | Note Deleted: 0176115 | |
| 2025-03-06 09:14 | egoitz | Note Deleted: 0176124 | |
| 2025-03-06 09:14 | egoitz | Note Deleted: 0176128 | |
| 2025-03-06 09:14 | egoitz | Note Deleted: 0176130 | |
| 2025-03-06 09:14 | egoitz | Note Deleted: 0176145 | |
| 2025-03-06 09:14 | egoitz | Note Deleted: 0176446 | |
| 2025-03-06 09:56 | hgbot | Merge Request Status | => open |
| 2025-03-06 09:56 | hgbot | Note Added: 0176517 | |
| 2025-03-06 10:28 | caristu | Steps to Reproduce Updated | View Revisions |
| 2025-03-10 11:17 | hgbot | Merge Request Status | open => approved |
| 2025-03-10 12:55 | caristu | Relationship added | related to 0057924 |
| 2025-03-10 16:11 | hgbot | Note Added: 0176622 | |
| 2025-03-10 16:11 | hgbot | Resolution | open => fixed |
| 2025-03-10 16:11 | hgbot | Status | new => closed |
| 2025-03-10 16:11 | hgbot | Fixed in Version | => PR25Q2 |
| 2025-03-10 16:11 | hgbot | Note Added: 0176623 | |
| 2025-03-10 17:09 | hgbot | Note Added: 0176626 | |
| 2025-03-11 10:36 | hgbot | Note Added: 0176648 | |
| 2025-03-11 10:36 | hgbot | Note Added: 0176649 | |
| 2025-03-11 10:41 | caristu | Status | closed => new |
| 2025-03-11 10:41 | caristu | Resolution | fixed => open |
| 2025-03-11 10:41 | caristu | Fixed in Version | PR25Q2 => |
| 2025-03-11 10:42 | caristu | Status | new => scheduled |
| 2025-03-11 10:42 | caristu | Relationship deleted | related to 0057924 |
| 2025-03-11 11:04 | caristu | Status | scheduled => resolved |
| 2025-03-11 11:04 | caristu | Resolution | open => fixed |
| 2025-03-11 11:04 | caristu | Review Assigned To | => alostale |
| 2025-03-11 11:04 | caristu | Status | resolved => closed |
| 2025-03-11 11:05 | caristu | Tag Attached: Performance | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |