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?
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.
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)?
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