Project:
| View Revisions: Issue #45710 | [ All Revisions ] [ Back to Issue ] | ||
| Summary | 0045710: Query to get characteristics model is taking more than 10 minutes. | ||
| Revision | 2021-01-11 17:47 by malsasua | ||
| Description | When executing a full refresh, on an environment with thousands of characteristics, the query is taking more than 10 minutes. Model: Characteristic Value Query: select characteri0_.M_Ch_Value_ID as col_0_0_, characteri0_.Name as col_1_0_, characteri1_.M_Characteristic_ID as col_2_0_, adtreenode2_.Parent_ID as col_3_0_, characteri0_.IsSummary as col_4_0_, characteri0_.Name as col_5_0_, characteri0_.Isactive as col_6_0_, characteri1_.Name as col_7_0_ from M_Ch_Value characteri0_ inner join M_Characteristic characteri1_ on characteri0_.M_Characteristic_ID=characteri1_.M_Characteristic_ID cross join AD_TreeNode adtreenode2_ where characteri1_.AD_Tree_ID=adtreenode2_.AD_Tree_ID and characteri0_.M_Ch_Value_ID=adtreenode2_.Node_ID and characteri0_.IsSummary='N' and (exists (select 1 from M_Product_Ch_Value productcha3_ cross join OBRETCO_Prol_Product obretco_pr4_ where productcha3_.M_Product_ID=obretco_pr4_.M_Product_ID and productcha3_.M_Ch_Value_ID=characteri0_.M_Ch_Value_ID and (obretco_pr4_.Obretco_Productlist_ID in ($1)))) and characteri0_.Isactive='Y' and adtreenode2_.IsActive='Y' and 1=1 and 1=1 and (characteri0_.AD_Client_ID in ('ED6E1C1132D840E2AC6A9932603E09B0' , '0')) and characteri1_.EM_Obpos_Useonwebpos='Y' and characteri0_.Isactive='Y' and (exists (select 1 from AD_Org organizati5_ where (organizati5_.AD_Org_ID in ($2)) and ad_org_isinnaturaltree(characteri0_.AD_Org_ID, organizati5_.AD_Org_ID, characteri0_.AD_Client_ID)='Y')) order by characteri0_.Name, characteri0_.M_Ch_Value_ID limit $3 |
||
| Revision | 2021-01-11 17:44 by malsasua | ||
| Description | When executing a full refresh, on an environment with thousands of characteristics, the query is taking more than 10 minutes. |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |