Subject Re: Dynamic Variable Instantiation Within A Stored Procedure
Author Adam
> 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?

Yes it is going to have several hundred thousand records. Remember
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.