Slow Product Info

[Pritesh Shah]

Hello All,

I am observing product info is very slow too load huge data in product table and many price lists. While analyzing i found that product info query takes more time in calculating bompricelist, bompricestd, bompricelimit. And reason is it iterates over loop for Bom in case price is 0 and M_Product_BOM table doesnt have M_Product_ID as indexed.

I did index and performance improved a lot.

Does anyone think would there be any other impact in case we index M_Product_ID in M_Product_BOM table?

Thanks,

Pritesh

[Pritesh Shah]

Carlos, do you think adding index on M_Product_ID column in M_Product_BOM table would be fine and no impact and would improve performance too? 

Looking forward for your reply.

[Carlos Antonio Ruiz Gomez]

Sounds good

--

[Pritesh Shah]

Carlos, Thank you very much for quick reply