Project:
| View Revisions: Issue #58073 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0058073: Performance: Slowness loading the Product window using the Openbravo Retail fashion module | ||
| 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 | ||
| 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. | ||
| Copyright © 2000 - 2009 MantisBT Group |
 |