SharePoint Search Results

Question

Hi,

We have customized SharePoint search to crawl external content type(SQL DB). This DB has 16 million records. All went well. The issue is that when the large subset of items is searched for (above 10 million) - there is a 4 second delay. This is not bad, but we need either to include a spinner or somehow decrease the load time to two seconds(maybe by limiting the result set).

We are using modified SharePoint search result template file which simply displays results in HTML table. I am not sure how can I modify this file to include a spinner since there is no Ajax call. If there is a way to limit the result set, we could do that too.

Thank you.

Answer 1

Thank you for you answer. We are in no position to add adjust hardware. 4 seconds loading is not a show stopper, I am looking only for either:

1. An indicator - spinner or " Loading...." message in the logic of the display template file, that is being displayed on the search page while the records are loaded. Is that possible as I cannot see anyone on the internet talking about this?

OR

1. KQL in Search Result Webaprt that is displaying this data with a tweak to have a limit to 100000 display results, like SQL has "Select top 1000"?

Thank you.

Answer 2

Hi, @Nemanja SOVIC ,

Per my knowledge, modifying display template will not help to improve performance. It will only change the way you view the results. The most straightforward way will be improving the spec of your servers or adding servers. Here is a blog you can refer to. However I am not sure if it is enough to decrease your load time to 2 seconds.

And you can have a try to increase the performance of the SQL DB.

---

If the answer is helpful, please click Accept Answer and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.