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.
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.
[It is appreciated to mark this as an answer if it helps you. It also encourages others to contribute.]
- Keep thinking of what's in the past only makes you away from moving forward.
smurtuza
Member
25 Points
88 Posts
Asp.Net Search Engine and more...
Jun 29, 2012 03:00 PM|LINK
Hi All,
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.
chsuan
Member
542 Points
77 Posts
Re: Asp.Net Search Engine and more...
Jun 30, 2012 04:10 AM|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.
- Keep thinking of what's in the past only makes you away from moving forward.