Chinaasp Forum Essence Post Full-text search technology Insider

Chinaasp Forum Essence Post Full-text search URL: http://search.chinaasp.com
Chinaasp Forum as a technical discussion of the Forum has been running for more than 2 years, accumulated a lot of technical information, although the forum itself has a query the essence of the function, but not full-text query, so to find information on the more troublesome. It is not easy to find the things you need in the face of many elite areas. Chinaasp has also been looking for appropriate solutions, in the existing limited hardware conditions, fully exert their usefulness, convenient for the vast number of technology developers to retrieve information for the Chinese Internet cause to do their own contribution.
Now we have succeeded in solving the problem. On the one hand, a powerful retrieval device, on the one hand, will not affect the performance of the server running the forum.
We made a search.chinaasp.com subdomain, pointing to another server with a relatively lighter load. and set a timed synchronization of 2 server data (mainly the forum essence of the data). So the function of Full-text search is entirely borne by search.chinaasp.com. For the www.chinaasp.com machine, there is no need to consider the full text search load, so as to ensure that the forum's normal operation is not affected.
Our Full-text Retriever is based on the full text Search feature of SQL Server7. It helps to establish a retrieval index and is updated regularly. This allows us to focus more on how to implement the function of the searcher, such as how we will determine the order in which search results are displayed, and how we should extract snippets of content that match the search. And what kind of search strategy should we use (the search strategy I'm talking about here is how to make the user find the results quickly), as well as the full use of caching to optimize the search.
The realization of the full text search of the essence post is just a preliminary experiment of our website content retrieval, in the foreseeable future, we will certainly put the whole content of the website into the search work area. We will provide better service for all of us. Please continue to support our work.