CF9's Apache Lucene vs SQL Server's full text search?

ColdFusion 9's full 开发者_Python百科text search is now based on Apache Lucene Solr (or Verity, but it has too much limitations). We also use SQL Server.

Which one's better? Which one's easier?

UPDATE: going to use for... searching against the name & description fields of the Products table.

Thanks!

Here's my 2 cents tested with ~ 3 000 000 of images with captions (primary key + image caption text from 100 to 500 chars):

CF9's Solr implementation is fast in returning results, really easy to setup, fairly fast during building index.

SQL Server 2005 FTS wasn't good enough, tried it some time ago and didn't put it in production. SQL Server 2008 FTS is much better though, currently using it on our application. But basic setup had to be adjusted in order to get high level results.

Based on experiences of other colleagues working with huge data sets and applications mostly based on search and finding things I made my top list:

1. Lucene
2. Tuned SQL Server 2008 FTS
3. Solr
4. SQL Server 2005

Of course CF9's Solr is winner here if you are chasing fast setup since you need 3 tags to finish the job and get awesome results.

The important question: What are you going to use it for?

Can't pick the right tool for the job when you don't know what the job is ;)