IContentLoader.GetItems executes netFindContentCoreDataByContentG

IContentLoader.GetItems executes netFindContentCoreDataByContentGuid for every item

Daniel

Vote:

Hi Everyone,

I am trying to load products (CatalogEntry) through IContentLoader but I had noticed performance issue. After investigation, most perfomance is lost for stored procedure netFindContentCoreDataByContentGuid that is called for every product(separately). Do you know how to force to skip execution of this stored procedure or use the one for batch: netFindContentCoreDataByContentGuidBatch?

Regards,
Daniel

#284573

Edited, Jul 28, 2022 15:51

Quan Mai

Vote:

If I remember correctly this is used to load the content data from the block. there is no way to make it called by batch unfortunately.

#284734

Aug 01, 2022 6:36

Daniel

Vote:

In my case this is caused by Assets on CatalogEntry item so for 100 products with 1 image there is 101 calls to database (ordinary n + 1 problem). Is there any way to load products with assets forcing to load assets by netFindContentCoreDataByContentGuidBatch (as I believe there is a purpose for this procedure)?

#284754

Aug 01, 2022 12:59

Quan Mai

Vote:

Right. So there is a bad and good news. Good news is that we identified the issue and fixed it. Bad news is that the fix is in 14.2.1. I don't know if Commerce team is willing to backport the fix to 13.x

#284808

Aug 02, 2022 6:56