Full Text Search

Hi,
I am wondering if *Full Text Search* is efficient or not (not too slow ?!)
with a table having more than 200.000 records ?
Thanks !Lionel,
Yes, it is efficient and not too slow with either FT Indexing or FT
Searching of a table with more than 200.000 rows.
In fact, Full-text Indexing (FTI) and Full-text Search (FTS) of a table with
200K rows is well within the "sweet spot" for not only SQL Server 7.0, but
SQL Server 2000 and SQL Server 2000 (Yukon) will rock for FT-enabled tables
of this *small* size!!
What is your primary concern? FTI or FTS performance with larger tables? If
you have a table with a more than 2 million rows, you may need to tune both
the hardware and software configurations, (see SQL Server 2000 BOL title
"Full-text Search Recommendations" for more details), but still you should
be able to FT Index million+ row tables.
Regards,
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Lionel" <nospam@.org.org> wrote in message
news:Of3BxwpDFHA.1496@.TK2MSFTNGP14.phx.gbl...
> Hi,
> I am wondering if *Full Text Search* is efficient or not (not too slow
?!)
> with a table having more than 200.000 records ?
> Thanks !
>|||I'm new to this - where can I find this doc Full-text Search recommendations
?
Looking for performance tuning tips. What is a BOL?
Thanks
"John Kane" wrote:

> Lionel,
> Yes, it is efficient and not too slow with either FT Indexing or FT
> Searching of a table with more than 200.000 rows.
> In fact, Full-text Indexing (FTI) and Full-text Search (FTS) of a table wi
th
> 200K rows is well within the "sweet spot" for not only SQL Server 7.0, but
> SQL Server 2000 and SQL Server 2000 (Yukon) will rock for FT-enabled table
s
> of this *small* size!!
> What is your primary concern? FTI or FTS performance with larger tables? I
f
> you have a table with a more than 2 million rows, you may need to tune bot
h
> the hardware and software configurations, (see SQL Server 2000 BOL title
> "Full-text Search Recommendations" for more details), but still you should
> be able to FT Index million+ row tables.
> Regards,
> John
> --
> SQL Full Text Search Blog
> http://spaces.msn.com/members/jtkane/
>
> "Lionel" <nospam@.org.org> wrote in message
> news:Of3BxwpDFHA.1496@.TK2MSFTNGP14.phx.gbl...
> ?!)
>
>|||You're welcome, Chris,
The BOL is short for "Books Online" and is the online (vs. printed)
documentation that ships with SQL Server 2000. You can also find an Internet
version of "Full-text Search Recommendations" at:
http://msdn.microsoft.com/library/d...m
er.asp
See also my blog entry: "SQL Server 2000 Full-Text Search Resources and
Links" at:
http://spaces.msn.com/members/jtkane/Blog/cns!1pWDBCiDX1uvH5ATJmNCVLPQ!305.e
ntry
Hope that helps!
John
--
SQL Full Text Search Blog
http://spaces.msn.com/members/jtkane/
"Chris" <Chris@.discussions.microsoft.com> wrote in message
news:93C06810-E298-4148-963F-79584FAAA640@.microsoft.com...
> I'm new to this - where can I find this doc Full-text Search
recommendations?
> Looking for performance tuning tips. What is a BOL?
> Thanks
> "John Kane" wrote:
>
with
but
tables
If
both
should
slow