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

Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Revisions: Issue #58073		[ Back to Issue ]
Summary	0058073: Performance: Slowness loading the Product window using the Openbravo Retail fashion module

Revision	2025-03-06 10:28 by caristu
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

Revision	2025-03-06 09:14 by egoitz
Steps To Reproduce	- On an environment with the retails fashion installed - Have characteristics and show the color, size and season table - Open the product window It takes seconds to show the data

Revision	2025-03-06 09:14 by egoitz
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.

Revision	2025-03-04 16:29 by egoitz
Steps To Reproduce	1- Configurate the relevant Characteristic in the product characteristic and configure the product with this Characteristic. 2 - Open the window Product

Revision	2025-03-04 16:29 by egoitz
Description	When we use the relevant Characteristic, we have a performance problem in the Product window, since the window query adds joins and this slows down the query.