How IQueryable and Take Can Kill Your Sitecore Solution?

We had a solution that had severe performance issues when it got a lot of visitors. Sitecore was casting the following exception and Solr had similar errors in its logs:

“Unable to read data from the transport connection: The connection was closed”

We recognized that the problem was caused by hitting the network bandwidth in the Azure!

Yes, there were a lot of visitors, true but enough were there to hit the bandwidth limit. The customer upgraded the plan to get more network bandwidth, but still the issues continued to arise.

But what is the issue that stops them from getting the result?

Once the review started of the Solr implementation, the issue was found very quickly.

The Take() was made after GetResults() was called, so the entire data set was returned to Sitecore from Solr, and then the take was applied to get the top 5 results.

This simple mistake caused all the network and performance issues.

Solution:

It was a simple fix to move the Take before GetResults so instead of the entire data set, Solr returned only the top 5 results to Sitecore and the processing time is reduced.

This is why I believe that you should always Introduce a (Solr) Sitecore Search Abstraction.

Mitesh Patel - Technical Head - ADDACT

Sitecore || XMCloud || OrderCloud Certified

Mitesh, a distinguished Technical Head at Addact/Addxp, is a prominent figure in Sitecore/XMCloud/OrderCloud certified writing. From Sitecore XM Cloud Developer Certification to Sitecore 10 .NET Developer Certification and Sitecore OrderCloud Certification, Mitesh's expertise is unparalleled. Mitesh is not only a skilled Sitecore CMS developer but also a 12+ years experienced software engineer proficient in various technologies such as MVC, ASP.Net, C#, jQuery, and Azure cloud/AWS.