Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Windows search ranking not return documents in expected order

Posted on 2014-12-09
4
363 Views
Last Modified: 2014-12-19
Hi All,

I am working with classic ASP and the Windows search using the server object Search.CollatorDSO.

My SQL query is as follows, which seems to work without issues other than the order in which it is returning the document results are not in an order I would have expected. This may be down to my limited understanding of the ranking algorithm being used...

SELECT top 1000 System.FileName, System.Search.Rank FROM SystemIndex WHERE scope='file:C:\inetpub\wwwroot\www\Search' AND NOT scope='file:C:\inetpub\wwwroot\www\Search\ex' and FREETEXT('phrase') order by System.Search.Rank desc  

Open in new window


What is happening at the moment is that some documents are showing rank of 999, although the word count (when checked in adobe pdf reader) is showing documents are incorrectly ordered, ie the top rated document with rank 999 could have 50 instances of a word, yet a document with the same rank has 100 instances of that same word. But is placed lower in the results. I would have expected the results with the most word count be placed higher?

Could anyone provide insight into why this could occur?
0
Comment
Question by:rito1
  • 2
4 Comments
 
LVL 24

Expert Comment

by:SunBow
ID: 40488785
You are selecting by rank and sorting by rank:
    - order by System.Search.Rank
You likely would fare better ordering by 'word count'
0
 
LVL 1

Author Comment

by:rito1
ID: 40488810
Thanks SunBow this does sound a better option in our case... Would you know the SQL syntax for order by word count?
0
 
LVL 33

Accepted Solution

by:
Big Monty earned 500 total points
ID: 40489081
you'd have to look in the SystemIndex table to see if there is any WordCount column. Remember, there is more to the Ranking than just a word count, there is how many times those words appear and how close together they appear, as well as many other factors.

you may want to have a look here for more info:

http://technet.microsoft.com/en-us/library/ff404224.aspx
0
 
LVL 24

Expert Comment

by:SunBow
ID: 40509047
:(
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
Possible fixes for Windows 7 and Windows Server 2008 updating problem. Solutions mentioned are from Microsoft themselves. I started a case with them from our Microsoft Silver Partner option to open a case and get direct support from Microsoft. If s…
This Micro Tutorial will give you basic overview of the control panel section on Windows 7. It will depth in Network and Internet, Hardware and Sound, etc. This will be demonstrated using Windows 7 operating system.
This Micro Tutorial will give you a basic overview of Windows DVD Burner through its features and interface. This will be demonstrated using Windows 7 operating system.

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question