|Subject||Re: Dynamic Variable Instantiation Within A Stored Procedure|
--- In firstname.lastname@example.org, Alexandre Benson Smith
> martinthrelly wrote:
> >hi one more question
> >the only downside i can see to using the BookWord architecture
> >describe, is that i will be in effect creating a row in thistable
> >for every unique word within every datarow record. is this tableto
> >going to become absolutely enormous?
> It will be huge, but I don't see a problem with it, you will need
> look at indices statistics after the table is populated to see ifyou
> have a lot of duplicates, if so, you could add the primary key tothe
> end of the table to help garbage collection process to run.your
> In the side of performance to query it I don't think it will be a
> problem, but I'd like to know the results you get and how big is
> I have posted a message some days ago about a pet project I have
> using full text search (in just one table) and I think could bedone to
> index the entire database, but I am short in free time to try itharder.
> I'd like to know your progress and how well it works and the
> find.yeah no problems. and thanks very much for your help! i will report
> see you !
> Alexandre Benson Smith
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil