Re: Integration of Lucene.Net and SQL Server 2005?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

On 11 Sep., 19:22, "Hilary Cotter" <hilary.cot...@xxxxxxxxx> wrote:
I am writing an article on it for simple-talk.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication book?http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com"DC"; <d...@xxxxxxxxx> wrote in message

news:1189525577.389287.163260@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx



On 11 Sep., 16:12, "Hilary Cotter" <hilary.cot...@xxxxxxxxx> wrote:
I did this. It works quite well. SQL FTS is faster at indexing and you
have
to jump through hoops to get Lucene working correctly, but properly done
it
is an alternative, especially when you need to do filtering.

--
RelevantNoise.com - dedicated to mining blogs for business intelligence.

Looking for a SQL Server replication
book?http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL
FTShttp://www.indexserverfaq.com"DC"; <d...@xxxxxxxxx> wrote in message

news:1189508864.757520.62150@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

Hi,

I am looking for an alternative to the SQL Server Fulltext Engine
since it is just not fast enough and does not offer the sorting I
require. Also, my customer wants a "did you mean google" when "gogle"
was entered feature. From what I have seen all that is possible with
Lucene.Net.

I am planning to export a table of about 3 Million keywords to
Lucene.Net and of course I have to implement a way to keep that index
up to date (a latency of one hour is allowed). Also, I would still
like to initiate searching through stored procs. Ideally a table-value
function with CLR integration would get a list of matching ID's from
Lucene.

I wanted to check if maybe someone has used such approach or heard
about something similar, or if there are general restrictions that
make the success of this approach unlikely.

TIA for any comments,

Regards
DC- Zitierten Text ausblenden -

- Zitierten Text anzeigen -

Thank you for letting my know, Hilary! That's encouraging. Do you
consider designing an "SQL Server / Lucene.Net Bridge" product?- Zitierten Text ausblenden -

- Zitierten Text anzeigen -

Thank you! I will wait for that article before I do anything.

Regards
DC

.

Relevant Pages

  • Re: freetexttable bug
    ... RelevantNoise.com - dedicated to mining blogs for business intelligence. ... Looking for a FAQ on Indexing Services/SQL FTShttp://www.indexserverfaq.com"Hilary Cotter" wrote in message ... considered as noise words thus not returning anything as oppose to ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Search and Index Question
    ... RelevantNoise.com - dedicated to mining blogs for business intelligence. ... Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.fulltext)
  • Re: Search and Index Question
    ... RelevantNoise.com - dedicated to mining blogs for business intelligence. ... Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.fulltext)
  • Re: freetexttable bug
    ... RelevantNoise.com - dedicated to mining blogs for business intelligence. ... We've been using the catalog as part of our search engine for a year ... I tried this query and I got a lot of rows. ...
    (microsoft.public.sqlserver.fulltext)
  • Re: freetexttable bug
    ... RelevantNoise.com - dedicated to mining blogs for business intelligence. ... Looking for a FAQ on Indexing Services/SQL FTS ...
    (microsoft.public.sqlserver.fulltext)