| Hi Timbo, Hope your very well. Many thanks for your feedback. We do support sorting of results by relevancy however this option does require the Full-Text option to be enabled... http://kb.instantasp.co.uk/Documentation/Setting-up-full-text-search-within-InstantKB.NET If you search our own knowledgebase here for say the term InstantKB.NET you'll see this in action. I appreciate your comments with regard to providing this as a standard feature however i doubt that would be possible. To provide this type of functionality some configuration would be required to setup a index or catalog. You would need to maintain a scheduled catalog / index as to pre-calculate an articles weighting based on the number of times certain keywords appears within it's body .I would not even consider calculating these weights in real-time as this would result in very poor search performance. To create such an index / catalog would require scheduling & fairly long executing SQL queries. ASP.NET does not lend it's self well to scheduling or running long SQL queries. The only approach i can see working to provide this ability outside of SQL Server would be to provide a Windows Service you run either on the web server or database server to maintain a local file based index. Again even this would require some form of configuration. This is something we have given some thought and may develop in the future. We opted to use the SQL Server full-text service to provide this functionality as it's a familiar feature to most dba's & .NEt developers. It's also a service most 3rd party hosting providers support. Of course you also get the reliability, performance & scheduling required through SQL Server. With SQL Server 2005 and IFilters it also makes the search extensible with the ability to search various file types that are attached to articles. I appreciate not everyone can use full-text and we have look at alternatives however all would require configuration for a index / catalog. Our search engine with full-text search enabled will offer the weighting and performance you require with hundreds of thousands of articles. If you have more than 1,000 articles i would strongly suggest you look at enabling full-text. You'll get much better performance and also results will be weighted & sorted by relevancy as you require. I hope this offers a little insight as to why weighting is not provided out-the-box. If the option is available to you i would suggest speaking with your host to see if they can't enable SQL Server full-text for your database.
Kindest Regards,
Ryan Healey
Director / Developer
 Explore our products...
http://demos.instantasp.co.uk/
|