Subject Re: [firebird-support] Re: Dynamic Variable Instantiation Within A Stored Procedure
Author Alexandre Benson Smith
martinthrelly wrote:

>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?

It will be huge, but I don't see a problem with it, you will need to
look at indices statistics after the table is populated to see if you
have a lot of duplicates, if so, you could add the primary key to the
end of the table to help garbage collection process to run.

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 your

I have posted a message some days ago about a pet project I have started
using full text search (in just one table) and I think could be done to
index the entire database, but I am short in free time to try it harder.

I'd like to know your progress and how well it works and the gotchas you

see you !

Alexandre Benson Smith
THOR Software e Comercial Ltda
Santo Andre - Sao Paulo - Brazil