search

sethura / vocadb

0 stars 1 forks source link

Use full-text search for entry searches #143

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago 
The performance of plain, unstructured character search might become a problem 
as the number of searched entries grows, especially for songs. The best way to 
handle this issue seems to be creating a full-text index for the searchable 
string fields. The features we need are very basic: no need for proximity 
search or synonyms.

Two alternative libraries/tools compatible with NHibernate/SQL Server:

NHibernate search: http://ayende.com/blog/3992/nhibernate-search
Integrates Lucene.NET into NHibernate. Need to make sure this works with recent 
NHibernate versions.

SQL Server full-text search index: 
http://technet.microsoft.com/en-us/library/ms142571.aspx
Need to make sure the NHibernate integration still works ( 
https://forum.hibernate.org/viewtopic.php?p=2386233 ).

Original issue reported on code.google.com by rii...@gmail.com on 21 Sep 2013 at 12:14

GoogleCodeExporter commented 9 years ago 
Tutorial for NHibernate Search: 
http://www.d80.co.uk/post/2011/03/04/Nhibernate-Search-Tutorial-with-LuceneNet-a
nd-NHibernate-30.aspx

Of course Lucene.NET could be used directly as well. The ability to index 
properties through associations (IndexedEmbedded) looks quite promising.

Original comment by rii...@gmail.com on 21 Sep 2013 at 12:23