0058167: Performance: Slow loading of Product window in Sales Order, Sales Quotation, Sales Purchase, Sales Invoice in the lines.

Description

When we want to create lines in Sales Order, Sales Quotation, Sales Purchase, Sales Invoice, and we select product, the window takes a long time.
This happens when there are several products.

In my case, takes 20''

Steps To Reproduce

If we did a sales order and create the line, click in product, open the window

QUERY

select
  pricingpro0_.M_ProductPrice_ID as,
  pricingpro0_.M_PriceList_Version_ID as m_pricel2__,
  pricingpro0_.M_Product_ID as m_produc3__,
  pricingpro0_.AD_Client_ID as ad_clien4__,
  pricingpro0_.AD_Org_ID as ad_org_i5__,
  pricingpro0_.IsActive as isactive6__,
  pricingpro0_.Created as created7__,
  pricingpro0_.CreatedBy as createdb8__,
  pricingpro0_.Updated as updated9__,
  pricingpro0_.UpdatedBy as updated10__,
  pricingpro0_.PriceList as priceli11__,
  pricingpro0_.PriceStd as pricest12__,
  pricingpro0_.PriceLimit as priceli13__,
  pricingpro0_.Cost as cost14__,
  pricingpro0_.Algorithm as algorit15__,
  pricingpro0_.EM_Obpos2_Taxcategory_ID as em_obpo16__,
  pricingpro0_.em_pos2plp_printpriceoptions as em_pos17__,
  pricingpro0_.em_obpos2_printpriceoptions as em_obpo18__,
  pricingpro0_.EM_Obpos2_Printpriceoptionsui as em_obpo19__,
  pricingpro0_.EM_Obpos_Maxprice as em_obpo20__,
  pricingpro0_.EM_Obpos_Skipapplypromotions as em_obpo21__,
  pricingpro0_.EM_Obpos_Useextpromotions as em_obpo22__,
  pricingpro0_.EM_Pos2plp_Attribute_1 as em_pos23__,
  pricingpro0_.EM_Pos2plp_Attribute_2 as em_pos24__,
  pricingpro0_.EM_Pos2plp_Attribute_3 as em_pos25__,
  pricingpro0_.EM_Pos2plp_Printing_Att1 as em_pos26__
from
  M_ProductPrice pricingpro0_
where
  pricingpro0_.M_ProductPrice_ID in (
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?,
    ?
  )

Issue History
Date Modified	Username	Field	Change
2025-03-06 13:48	sofidossant	New Issue
2025-03-06 13:48	sofidossant	Assigned To	=> Triage Platform Base
2025-03-06 13:48	sofidossant	Triggers an Emergency Pack	=> No
2025-03-06 13:50	Practics	Issue Monitored: Practics

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.