.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Search is very very slow.

Posted By:      Posted Date: April 10, 2011    Points: 0   Category :C#


I am having a 2- Server(App n DB) topology on which MOSS 2007 has been installed.

We are having users around 2000. We are facing issue with the search functionality, which is very slow. Infact its not returning any results and just pauses.

I have checked out the Admin site - Search Adminsitration. I have seen couple of errors in Active Crawls content source. But dont know how to acces them.

Please help me out with same.



View Complete Post

More Related Resource Links

FAST search query is slow...

Hi, we are using fast search for sharepoint 2010. We are crawling an external data source and this is used for search queries. we have around 30 metadata properties and all are full-text indexed. however, the search operation is slow for a database of 5k records in intranet (webserver and database server are in different geographic regions). typically a 100 item search takes 9-10 sec. it get worse over internet and the search query varies from 10-45 sec for 100 items. Any pointers will be helpful. thanks.  

Random slow search queries


Hi all,

I've been noticing some erratic behavior from our query servers with some searches taking unusually long time to execute. Digging through logs doesn't really show anything, except for entries like :

10/11/2010 13:14:21.53     w3wp.exe (0x1390)   ...    Entering monitored scope (RefinementManager.GetRefinement(Dictionary<string, ictionary<string, RefinementDataElement>>, XmlDocument, int)) 

10/11/2010 13:14:31.69     w3wp.exe (0x1390)    ...   Leaving Monitored Scope (RefinementManager.GetRefinement(Dictionary<string, Dictionary<string, RefinementDataElement>>, XmlDocument, int)). Execution Time=10150.0660000084    

So it took at least 10 seconds to run this search, while others may take less than half a second. Any ideas what that might be?


Search Server 2010 slow crawls on CMS 2.0

My client is crawling a CMS 2.0 installation with SharePoint Search Server 2010 and we are noticing that crawls on this content source for roughly 250K pages can take anywhere between 1-3 days.  As a comparison, our WSS 3.0 farm, with roughly 150K items, finishes a full crawl in slightly under 7 hours.

I am trying to troubleshoot why the CMS crawl is taking so long.  We have a small farm configuration with a dedicated DB server (which is a cental server for all applications requiring databases organization wide), a single crawl server hosting CA and the crawler component and two WFE/query servers that have one index partition spread over both of them.  All servers are virtualized Windows 2008 SP2 64-bit instances.

The CPU on the crawl server is pinned at 100% during crawls, usually consumed between various msdmn.exe processes and the mssearch.exe process.  The crawl server consistently uses roughly 3GB of the 4GB of allocated memory (I have advised them to at least double the amout of RAM, though Microsoft's recommendation of 16 GB per server would be the best practice.  This request is in process and it takes the organization a couple of weeks to fulfill any hardware upgrade requests!).

Here are some steps I have taken in an attempt to alleviate the slowdown

People search for AD user is very slow


People search for AD user is very slow, takes about 40 seconds to find a user. We are runing MOSS 2007 SP2 (64 bit win 2008 STD) and have 2003 AD. DC is local to the MOSS serers. Network and DNS are ok too. What esle can I do to fix this issue. 

Slow fulltext search



I have a problem with full text search. It runs very slow. Originaly I thought that our server doesn't have enough memory to cache full text catalog and has to read it from the disk every time. But I ran single containstable statement on the server and it returned results instantly. So I guess the problem is in joining containstable results with other tables, Views.  I understand that containstable runs separately and the query is passed to MS Search Engine which returns results to SQL and merges them with the rest of the query. But I am not able to figure out what exactly causes the entire query to slow down. I also noticed that Order By rank desc slows down performance even further. But I need to show most relevant results first. Also, similar query without containstable works quite well. Below is the simplified version of my query along with the execution plan. Please help me to understand/solve this problem. We have SQL 2005 Workgroup edition, Windows 2003 server Standard edition. 4GB ram. Database size 55GB. Full text catalog size 600 Mb.


select top 60 
rn = ROW_NUMBER() OVER (ORDER BY key_tbl.rank desc),
productslocation_pid, min(ProductsLocation_price) minprice,
max(ProductsLocation_price) maxprice, count(*) BCNT, rank
from containstable (products, txtcat, 'video') as key_tbl
inner j

People search for AD user is very slow


People search for AD user is very slow, takes about 40 seconds to find a user. We have Sharepoibnt 2010.

I'v found this article


But We have trust with other computer, which is in the other country. We don't delete it.

What way can you offer?

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

SharePoint Gets Search Analytics

Microsoft's SharePoint Portal Server 2003 was sold into a large number of organizations based solely on the strength of the search tool. Organizations hungered for a way to find the data they had generated.

Using SharePoint Search feature in ASP.Net Application

Integrating ASP.Net application in to MOSS 2007 to utilize SharePoint Enterprise Search Feature can be done by using Business Data Search.

Get more then google search from here

Just make it home page and enjoy more then google search you not only get google result and prizes for searching but also free ebooks and link from here like orkut,facebook,twitter,yahoomail etc...


Adding Search Refinements in SharePoint 2010

I have been playing around with SharePoint 2010 Search this morning. I love the new UI. The search refinements panel is just begging to be messed with. In my case I wanted to add the file extension JPG as an Image Type refiner.

Search Engines and Multilanguage Websites - using .resx


I have a website (asp.net 3.5+c# +linq ) having thopition to change languages (2) by the user, Am using the search engine like in the example of:


this search will find any searched word in all the pages and return the link in the default language of the site, but problem for the second language , because by default the site language is English and the user have the option to change to other language.

and as I understood that the .resx files can not be searched like the aspx by the search engines.

I looked in many blogs and discussion boards for similar  case but unfortunately no clues on this issue .
The only same case posted :


and also I could not find any clue to move on, 

 Kindly requsted to guide me for the soultio

Thanks for your time and wish you all the best
your help is always appreciated


Response.Redirect slow


I'm in the middle of migrating servers and on the new server Response.Redirect is extremely slow. It takes around 20 seconds for the browser to get the redirect. This is something that was quick on the existing server. It's an ASP.NET 2.0 application, both servers are running IIS6.

Additionally, if I "manually" do the redirect, it's fast. For example:

Existing way:


takes around 20 seconds on the new server

New way:

Response.Status = "302 Moved Temporarily";
Response.AddHeader("Location", url);

is fast on the new server.

Any ideas why Response.Redirect would be so slow on the new server?

how to make a dropdownlist looks like google search box


dear all...

any idea how to do that ?

Thnx in advance

VS 2010 Pro is slow



I was wondering if anybody else is finding VS 2010 extremely slow loading a solution - and it pretty much renders the rest of the machine useless until loaded. Everything is slowed to a halt.

I upgraded from VS 2005 - now I think I made a terrible mistake. I cannot afford to try and load 2 solutions simultaneously.

The machine is a Core2 Duo E8400, 3GB of RAM, WinXP SP3. Max I can go to is 4GB. Would upgrading to a 64-bit OS really be worth it (actually only to get 8GB of RAM)?

I'm hoping someone else has found a solution to this particular problem.



Membership Search user


Is there a membership function to search a username Like this:   LIKE '%UserName%' ?

This is not working.

MembershipUser User = Membership.GetUser("%" + TextBox1.Text + "%");

Thank you.

Search for a string in my datasource dynamically


I am displaying an Rssfeed on my page by using XmlDataSource and Datalist controls.

I want the user to be able to limit the information that is returned to my datalist.  To do this I have a textbox on the form that allows the user to enter their search criteria.

I need to be able to dynamically create a query string utilizing the information that the user entered in the textbox.  I am also using a drop down list and allowing the user to select whether they want to search in the title, description, or all parts of the xml file.

I am having trouble figuring out how to reference the data contained in my textbox in my query string.  Where the query string says 'asp', I want to replace 'asp' with the content from my sSearch variable.  Can anyone tell me how to reference my variable in the query string???

string sSearch = txtSearch.Text;
        string SQuery = "";

        if (DropDownList2.SelectedIndex == 0)
            SQuery = "[contains(title), 'asp')]";

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend