Openbravo Issue Tracking System - POS2 |
| View Issue Details |
|
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0058073 | POS2 | Fashion | public | 2025-02-25 14:23 | 2025-03-11 11:05 |
|
| Reporter | sofidossant | |
| Assigned To | caristu | |
| Priority | high | Severity | major | Reproducibility | always |
| Status | closed | Resolution | fixed | |
| Platform | | OS | 5 | OS Version | |
| Product Version | pi | |
| Target Version | | Fixed in Version | | |
| 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; |
| Additional Information | |
| Tags | Performance |
| Relationships | | depends on | backport | 0058196 | 25Q1.1 | closed | caristu | Performance: Slowness loading the Product window using the Openbravo Retail fashion module | | depends on | backport | 0058197 | 24Q4.2 | closed | caristu | Performance: Slowness loading the Product window using the Openbravo Retail fashion module |
|
| Attached Files |  sqlformatter.sql (8,964) 2025-02-25 17:41
https://issues-new.openbravo.com/file_download.php?file_id=20965&type=bug |
|
| 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 | bug_revision_view_page.php?rev_id=29305#r29305 |
| 2025-03-06 09:14 | egoitz | Steps to Reproduce Updated | bug_revision_view_page.php?rev_id=29307#r29307 |
| 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 | bug_revision_view_page.php?rev_id=29310#r29310 |
| 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 | |
|
Notes |
|
|
(0176517)
|
|
hgbot
|
|
2025-03-06 09:56
|
|
|
|
|
(0176622)
|
|
hgbot
|
|
2025-03-10 16:11
|
|
|
|
|
(0176623)
|
|
hgbot
|
|
2025-03-10 16:11
|
|
|
|
|
(0176626)
|
|
hgbot
|
|
2025-03-10 17:09
|
|
|
|
|
(0176648)
|
|
hgbot
|
|
2025-03-11 10:36
|
|
|
|
|
(0176649)
|
|
hgbot
|
|
2025-03-11 10:36
|
|
|