Test the relevance sorting of sql2000 query results. It sounds attractive to sort the relevance of sql2000 query results, but it can be implemented. On the Internet this morning, I saw an article about how to sort the relevance of sql2000 query results using Microsoft indexserver for full-text query. it sounds very attractive, but it can be implemented.
On the Internet this morning, I saw an article using Microsoft index server for full-text query (this was also seen before, and also included such a query function in computer management)
My IIS default web server contains more than 0.1 million html documents under g:/wwwroot.
Test: strSearch = "SELECT DocTitle, Path, FileName, Characterization, Size, write, RANK "&_
"From scope ()"&_
"Where contains ('" & Request. Form ("txtSearchFor") & "') order by rank desc" also performs relevance sorting. I have no specific time overhead.
But it is acceptable, and it is very fast when turning pages. However, the biggest drawback is that you can only index static pages.
In the afternoon, I indexed the database of the previous more than 0.5 million records (mainly song and singer names) in sql2000 and started testing at night.
Test 1: "select top 26 * from song1 where contains (songtitle, 'love')", no processing is performed on the result, just in ascending order of ID
The time overhead is basically 0.016 s, and the speed is satisfactory. at least I don't feel slow.
Test 2: The rank value is used for relevance sorting. "order by rank desc" or "order by rank asc", the query results are satisfactory and compared in terms of sorting quality.
Accurate, whether it is the use of or and for multi-keyword sorting during query, but I can't stand the time overhead, it is between 6 s and 8 S,
Cpu usage is also high.
I see that the relevance sorting of other searches on the Internet is relatively fast. I have not studied the open-source Lucene because I do not understand java.
However, I think it would not be slow to query the relevance of each keyword during indexing. I am also depressed.
Bytes. On the Internet this morning, I saw an article about full-text query using Microsoft index server...
