To make my database quickly searchable, I was considering the following:
1) Putting the value of the rich text editor into a SQL text.
2) Removing the markup and parsing the actual text and saving each distinct word into a table such as:
KEY ](Unique key identifiying the record to which the rich text is associated), bigint
WORD, varchar(200)
Does anyone have any better ideas? Will I run into problems with too many records in my "word" table? Is there a practical limit (SQL 2005) that will be exceeded?
Is it possible to set a maximum character cound on the input? Is this maximum based upon actual text or the markup text?
How are other people handling these situations?
Thank you.
1) Putting the value of the rich text editor into a SQL text.
2) Removing the markup and parsing the actual text and saving each distinct word into a table such as:
KEY ](Unique key identifiying the record to which the rich text is associated), bigint
WORD, varchar(200)
Does anyone have any better ideas? Will I run into problems with too many records in my "word" table? Is there a practical limit (SQL 2005) that will be exceeded?
Is it possible to set a maximum character cound on the input? Is this maximum based upon actual text or the markup text?
How are other people handling these situations?
Thank you.