Search is slow in the site

Question

Hi,

I have developed a shopping website using the Starter site. In the starter site, there exists the Search functionality where we can search for the itesm. I have modified the search results by adding some new fields, but now on doing search, it is taking time to load the results. What could be the reason? please give an idea on this..

Regards,
Ginu

Answer 1

Have you seen any errors in the event log? Commerce server relies on SQL Server full text search. Can you rebuild your indexes and check if you gain any performance.

Regards,
-Ravi Kanth Koppala

---

http://techblog.ravikanth.net (If this post answers your question - Either Mark this post as the answer or vote as being useful.)

Answer 2

Hi Ravi Kanth,

The Search result is slow only on searching first time. On subsequent searches, it is showign the results fast. But on keeping the site idle for sometime or accessing the site after some hours and then on searching, the result is slow on first time. What could be the reason for the slowness on first time search. Please help me on this.

When i debugged the code, it is executing time on the code : returnValue = search.Search(out totalRecords); in FreeTextSearchDataSource.cs under commerce components.

Regards,
Ginu

Answer 3

Hi ravikanth,

For updating the Index, Is it enough through executing the stored procedure as

Exec ctlg_UpdateIndexes '@CatalogName'

Regards,
Ginu