Umbraco Examine or straight Lucene for indexing SQL data?
I have a page on my site where we can search for people in a SQL table. Right now, I am using SQL queries to check the first name column, last name column, etc. for matches to the search term(s). I'd like to switch this over to Lucene.NET to be more accurate and efficient as well as add the ability to search more columns.
Should I just use Lucene or can I use Umbraco Examine (which I know is Lucene underneath). I've got a simple search returning results from Umbraco content. Now, I need to perform a proof of concept with SQL data. The FrarmCode.org's example uses an XML datasource.
Do I need to convert my SQL query results to XML for feeding my Examine index? Or can I use a recordset/datatable to feed the index?
Umbraco Examine or straight Lucene for indexing SQL data?
I have a page on my site where we can search for people in a SQL table. Right now, I am using SQL queries to check the first name column, last name column, etc. for matches to the search term(s). I'd like to switch this over to Lucene.NET to be more accurate and efficient as well as add the ability to search more columns.
Should I just use Lucene or can I use Umbraco Examine (which I know is Lucene underneath). I've got a simple search returning results from Umbraco content. Now, I need to perform a proof of concept with SQL data. The FrarmCode.org's example uses an XML datasource.
Do I need to convert my SQL query results to XML for feeding my Examine index? Or can I use a recordset/datatable to feed the index?
Anyone have working sample code they can share?
is working on a reply...