Re: Full text searching on a bulletin board system
From: John Kane (jt-kane_at_comcast.net)
Date: 10/14/04
- Next message: Duncan Welch: "Re: WEIGHT confusion (SQL 2k, running on Win2k3)"
- Previous message: Daniel Crichton: "Re: Does FTS in SQL 7 have known issues with not indexing records?"
- In reply to: Shabam: "Re: Full text searching on a bulletin board system"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 14 Oct 2004 01:42:46 -0700
Shabam,
Q. Are there any times when it wouldn't be good to use the full text
searching of MS SQL?
A. This would depend upon the type, amount and frequency of non-FTS type SQL
queries that for your application consume &/or use significant portions of
your server's CPU, Memory and disk I/O (assuming that you have separated the
FT Catalog from your database files). What is your application's workload?
Is it heavy OLTP or OLAP? primarily a web site host with lots of searchers?
Depending upon these answers, you would want to schedule your Full &/or
Incremental Populations around the time periods of your most active
(non-FTS) SQL query processing. If you have a dual or multi-proc server, you
can separate the MSSearch cpu usage from your MSSQLServer cpu usage as well.
Let me know if you have any other questions!
Thanks,
John
"Shabam" <blislecp@hotmail.com> wrote in message
news:zvCdnWrP0ZOIifPcRVn-sA@adelphia.com...
> "Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
> news:uXpTI3IsEHA.2340@TK2MSFTNGP11.phx.gbl...
> > That depends on the frequency of updates, the size of the data you are
> > indexing, the number of CPUs, and your horsepower.
> >
> > In general it doesn't consume significant cpu for long periods. You may
> > notice some CPU spiking with German or the Far Eastern word breakers.
>
> Thanks! That was very helpful.
>
> Are there any times when it wouldn't be good to use the full text
searching
> of MS SQL?
>
>
- Next message: Duncan Welch: "Re: WEIGHT confusion (SQL 2k, running on Win2k3)"
- Previous message: Daniel Crichton: "Re: Does FTS in SQL 7 have known issues with not indexing records?"
- In reply to: Shabam: "Re: Full text searching on a bulletin board system"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
