Last post Jun 30, 2012 05:10 AM by chsuan
Jun 29, 2012 04:00 PM|smurtuza|LINK
I'm currently working on a Knowledge Base project. The articles data is stored in table fields. Each article may have downloads/attachments associated with and they are also stored in the tables.
One of the main issue is the search capabilites. Currently it uses SQL FreeTextTable/ContainsTable search method. For some reason the search is pretty premitive and does not give desired results as adverstised. For example, partial string search is not supported.
We decided to use a third party search engine. I'm currently evaluating dtsearch and lucene.net.
Besides doing a string search the application also provides other fields as a filters to search. I wanted to see an advise from the experts to guide me in the right direction here. Thank You.
Jun 30, 2012 05:10 AM|chsuan|LINK
We have used Lucene.Net for many projects (small to large scale) and it works well. However you do need to think before you implement it. For example, what fields needs to be stored but not indexed (and vise versa) in the index and what kind of search capabilities
you want to achieve.
Another good one is Solr (built on top of Lucene). It comes with many powerful features such as built-in facet search, you might also want to have a look. The thing I don't like it is it needs a Tomcat server hosting its web service (I prefer everything
in .NET to reduce the complexity, but this is my own opinion).
Hope this helps.