Full Text Index

Forum Moderators: open

Message Too Old, No Replies

Full Text Index

side effects?

BlackTulip

4:08 pm on Jul 26, 2006 (gmt 0)

Hi,

I am planning to provide a search feature for my site(forum like), which would entail searching a Nvarchar(500) column. so, if i go down the MS SQL full-text-index path, what are the ramifications? any performance loss? can i do it live?

thanks
-BT

BlackTulip

7:57 pm on Jul 28, 2006 (gmt 0)

any comments?

syber

8:03 pm on Jul 28, 2006 (gmt 0)

Searching a Nvarchar(500) column would not require the use of FullText indexing unless you need to use some of the proximity search and word stemming features.

BlackTulip

9:34 pm on Jul 28, 2006 (gmt 0)

unless you need to use some of the proximity search and word stemming features

good point. I think i can do w/o those perks.

also i was just reading that MS recommends not surpassing 1 million rows per table for full indexing.

Full Text Index

side effects?

BlackTulip

BlackTulip

syber

BlackTulip

Join The Conversation

Moderators and Top Contributors

Hot Threads This Week