Hi,

I am using product code in url but my code not startdard it include some special characters. So i have to normalize it and then add to url

from normalize code in url i can't denomalize to actual code to get product by ContentRepository so i have to query to episerver FIND to get product

The issue is that, time to query to find to get product too long lead to performance impact

    //incoming
        protected override CatalogContentBase FindNextContentInSegmentPair(CatalogContentBase catalogContent, SegmentPair segmentPair, SegmentContext segmentContext, CultureInfo cultureInfo)
        {
            while (!string.IsNullOrWhiteSpace(segmentPair.Next) && segmentContext.RequestUrl.IsAbsoluteUri &&
                   segmentContext.RequestUrl.AbsolutePath.Contains("/product/"))
            {
                if (catalogContent.ContentType == CatalogContentType.Root)
                {
                    var code = $"{Constants.ARTICLE_PREFIX}_{segmentPair.Next}";
                    // Performance issue here
                    var singleProduct = _queryService.FindProductByNormalizeCode(code, _currentMarket.GetCurrentMarket().MarketId.Value);

                    if (product != nul)
                    {
                        if (contentLoader.TryGet(contentLink, out ProductContent product))
                        {
                            return product;
                        }

                        return singleProduct;
                    }
                }
                segmentContext.RemainingPath = string.Empty;
                segmentPair = segmentContext.GetNextValue(segmentPair.Remaining);
            }

            return base.FindNextContentInSegmentPair(catalogContent, segmentPair, segmentContext, cultureInfo);
        }

So my question:

Is there any way to get product by nomalize code from episerver

Thanks,

Thang Le