|Subject||Re: Dynamic Variable Instantiation Within A Stored Procedure|
>Yes it is going to have several hundred thousand records. Remember
> hi one more question
> the only downside i can see to using the BookWord architecture you
> describe, is that i will be in effect creating a row in this table
> for every unique word within every datarow record. is this table
> going to become absolutely enormous?
though, there will be a lot of repeated words in titles, and you are
unlikely to encounter anywhere near this many.
In case I didn't mention, in the table
Words (ID, Value)
Store Value in upper case, and put an index on Value. That will make
searching fast. You do not want "firebird" and "Firebird" to get two
separate lines after all.