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-06 10:28 | |||||||
| Reporter | sofidossant | View Status | public | |||||||||
| Assigned To | caristu | |||||||||||
| Priority | high | Resolution | open | Fixed in Version | ||||||||
| Status | new | 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 | ||||||||||
| Review Assigned To | ||||||||||||
| 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 | No tags attached. | |||||||||||
| 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 [^] |
|
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 | 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 | Note Added: 0176517 | |
| 2025-03-06 10:28 | caristu | Steps to Reproduce Updated | View Revisions |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |