--- In firebird-support@yahoogroups.com, Alexandre Benson Smith
<iblist@t...> wrote:

>
> martinthrelly wrote:
>
> >thanks.
> >
> >
> >
> >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?
> >
> >
> Martin,
>
> 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

> tables.
>
> 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

> find.
>
> see you !
>
> --
> Alexandre Benson Smith
> Development
> THOR Software e Comercial Ltda
> Santo Andre - Sao Paulo - Brazil
> www.thorsoftware.com.br
>

yeah no problems. and thanks very much for your help! i will report
back.