Will Fast Text Search scale and perform well on large data? Is anybody
successful with it in a big way? Who?
Thanks,
TI assume you mean, "Full Text Search"? It can be made to scale, yes--I'm
aware of some massive web sites that are using it. That said, to make it
scale in certain scenarios you need to use some tricks. I recommend reading
the following:
http://www.microsoft.com/technet/pr...e/ftslesld.mspx
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
news:eVdtMeAuHHA.3404@.TK2MSFTNGP03.phx.gbl...
> Will Fast Text Search scale and perform well on large data? Is anybody
> successful with it in a big way? Who?
> Thanks,
> T
>|||If you do mean Fast Text Search (http://www.fastsearch.com/) and not SQL
FTS, it is extremely fast but requires an index which is at least the same
size of the data you are indexing.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
news:eVdtMeAuHHA.3404@.TK2MSFTNGP03.phx.gbl...
> Will Fast Text Search scale and perform well on large data? Is anybody
> successful with it in a big way? Who?
> Thanks,
> T
>|||I just took a quick glance at the web site, and it looks like it doesn't
work inside of SQL Server? If that is the case, why not just use Lucene?
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%239qunrCuHHA.768@.TK2MSFTNGP04.phx.gbl...
> If you do mean Fast Text Search (http://www.fastsearch.com/) and not SQL
> FTS, it is extremely fast but requires an index which is at least the same
> size of the data you are indexing.
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Tina" <TinaMSeaburn@.nospamexcite.com> wrote in message
> news:eVdtMeAuHHA.3404@.TK2MSFTNGP03.phx.gbl...
>|||FAST is faster than Lucene. The support for FAST is better than lucene, well
let me rephrase that, you have to pay for support for FAST, whereas with
lucene its free, and you get what you pay for.
So if you need speed (like acoona.com), you might want to use FAST. If you
want to do things on the cheap (like technorati) use lucene.
As you point out neither FAST nor lucene are integrated into SQL Server so
you have to do some work to get them to index database content.
--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Adam Machanic" <amachanic@.IHATESPAMgmail.com> wrote in message
news:%23G7PhtCuHHA.668@.TK2MSFTNGP05.phx.gbl...
>I just took a quick glance at the web site, and it looks like it doesn't
>work inside of SQL Server? If that is the case, why not just use Lucene?
>
> --
> Adam Machanic
> SQL Server MVP
> Author, "Expert SQL Server 2005 Development"
> http://www.apress.com/book/bookDisplay.html?bID=10220
>
> "Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
> news:%239qunrCuHHA.768@.TK2MSFTNGP04.phx.gbl...
>|||"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:OFasZ8EuHHA.4476@.TK2MSFTNGP03.phx.gbl...
> FAST is faster than Lucene. The support for FAST is better than lucene,
> well
Wikipedia uses Lucene. Fast enough for the number 10 web site in the US ==
probably fast enough for me
Adam Machanic
SQL Server MVP
Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220
No comments:
Post a Comment