0058196: Performance: Slowness loading the Product window using the Openbravo Retail fashion module

Openbravo Issue Tracking System - POS2

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0058196

POS2

Fashion

public

2025-02-25 14:23

2025-03-11 10:54

Reporter

sofidossant

Assigned To

caristu

Priority

high

Severity

major

Reproducibility

always

Status

closed

Resolution

fixed

Platform

OS Version

Product Version

Target Version

25Q1.1

Fixed in Version

Merge Request Status

approved

Review Assigned To

OBNetwork customer

OBPS

Support ticket

122020

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

Summary

0058196: 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